AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N5533QBoldt Matthew Frederick · Santa Fe, NMN5533RThompson Aaron R · Louisville, KYN5533SNgb Construction Inc · Ceres, CAN55340Air55 LLC · Charleston, WVN55342Dienwiebel Thomas · Santa Cruz, CAN55345Arrow Flite LLC · Chino Hills, CAN55347Roze Scott L · Port Orange, FLN55349Mob Aviation LLC · Auburndale, FLN5534ELindsey Kelly M · Throckmorton, TXN5534KAerolife Aviation LLC · Knox, INN5534NClifford English · Mesa, AZN5534QPaul Richard W · San Jose, CAN5534RHanson David J · Charlotte, NCN55350Haps Air Inc · Ames, IAN55359Uribe Roberto · Houston, TXN5535BAvery John W · Fergus Falls, MNFirst renewal noticeN5535FTrent Donald R · Rustburg, VAN5535JBreadner Robert A · OntarioNon-citizen corporation, flight hours not reportedN5535KHays Cory · Beaumont, TXN5535MButz Jonathan O · Mansfield, OHN5535NBerry William Trustee · Harrison, ARN5535QJohnson Bar Inc · Pensacola, FLN5535WGpd LLC · Saint Louis, MON55363Hardin John M · Terrell, TXN55364Cremel Roberto J · Trumbull, CTN55367Mammoth Toys Inc · Santa Ana, CAN5536BHigh Five Flying LLC · Amarillo, TXN5536DLett Laura D · Dallas, TXN5536EJeffries And Hendley LLC · Greenwood, INN5536FArnt James R Jr · Worthington, MNN5536JHanna Patricia A · Davis Junction, ILN5536LAdvance Air LLC · Wichita, KSN5536NBrown Peter L · Riverton, CTN5536PGryhon Designs · Camden, SCN5536QWokini Air LLC · Tarpon Springs, FLN5536UPittman Discover Flight LLC · Oshkosh, WIN5536WSchilke Kenneth · Imperial, NEN55372Mccarroll Daniel C · Saint Augustine, FLN55374American Patrols Inc · Midland, TXN55378Iacobacci Timothy · Fairborn, OHN5537CM G Aviation · Tyler, TXN5537KSales First LLC · Jasper, GAN5537MWiglesworth David G · Lenexa, KSN5537PField Gerard · Middleboro, MAN5537RBalady Nabih · Santa Clarita, CAN5537SMcpeak Alan W · Colorado Springs, CON5537VWheelzup LLC · San Carlos, CAN5537XKelly Douglas E · Lake Ozark, MON55380Clark Joseph David · Kilgore, TXN55383Winkelman James R · Zionsville, IN
Back to AD 2007-04-19 R1