AD 2004-19-01
Registered aircraft · 30,427
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2004-19-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-19-01')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2004-19-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-19-01') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1114YThompson Randy L · Anderson, CAN1116DOxman Warren L · Rhome, TXN11172Skaaire Society · Madison, WIN1117THimes Austin M · Wentworth, MON1119DChumble Ameya A · Duluth, MNN111ATSkymaster Stc LLC · Mena, ARN111EZMayes Robert C · Boise, IDN111GZRabinowitz Warren · Ramrod Key, FLN111HSMacav Flight Training LLC · Abilene, TXN111KSKilo Sierra LLC · Monticello, INN111LKnuth Dale G · Hartford, SDN111MFField Monica · Los Angeles, CAN111NJNew Jersey Forest Fire Service · Trenton, NJN111NZBlackerby Kevin W · Spicewood, TXN111PWKilgore Eric M · Genoa, NVN111TBNeswest Inc · Los Angeles, CAN111TKMclendon Thomas A · Crockett, TXN111WFArnold Frank W · Senoia, GAN1120DCompher Charles D · Berryville, VAN1120FHaidle Wayne M · Bismarck, NDN1121DVancuren Mary Ann · Owasso, OKN1121TWaddell Richard K Jr · Loveland, CON1121YShaw Michael B · Ridgeland, WIN11226Box Jon A · Carrizo Springs, TXN1122DBeech O Sphere LLC · Casper, WYN1122FDollosso Frank G · Lakeport, CAN1124BAlaska Homestead Lodge Inc · Soldotna, AKN1125DStarr Eric M · Queen Creek, AZN1125FAeropark LLC · Michigan City, INN1126AEberling Joan P · Central Point, ORN1126DHynds Michelle S · Addison, TXN11271No Coop Cardinal LLC · Sonoma, CAN1127FPricemeyer Aviation LLC · St Pete Beach, FLN1127YWong David · Torance, CAN1128FLockridge James · Adairsville, GAN1128YPerez Donna · Chico, CAN1129DKogl John L · Valparaiso, INN1129FKoch Bradley D · Billings, MTN1129MTechair LLC · Playa Vista, CAN112LDMartin Joseph S · Carrollton, KYN112LNBruce James W · Searcy, ARN112NBillingsley Carl · Henderson, TXN112NCFrance Jay D · Colbert, GAN112NL1st American Aviation Inc · North Miami, FLN112QBFloyd Austin · Searcy, ARN112RPTaylor Chad A · Enid, OKN112VBHatley Ralph A · Eagle Creek, ORN1130FMonahan William T · Vestal, NYN11330Leikala Douglas A · Fairport Harbor, OHN1133DBohl Howard M · Temecula, CA
Back to AD 2004-19-01