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.
N41BPSturdevant Harold L Jr · Kalispell, MTN41BXWilliams Paul E · Kendallville, INN41CEWhats Up Doc Aviation LLC · Alexander, ARN41CHLaperle Brian D · Colebrook, NHN41CSSanders Aviation Services LLC · Hedgesville, WVN41CVGoldfinger Chris · Albany, ORN41DBryson Zachary · Redondo Beach, CAN41DCDc Aircraft LLC · Shreveport, LAN41DDDurbano David · Jackson, WYN41DLLdair Inc · Roanoke, VAN41DMMission Air LLC · Oklahoma City, OKN41DNNevels Donald L · Everton, MON41EBCoakes Randall S · Lafayette, INN41ECTreeline Helicopters Inc · Bristol, TNN41EGSal Aviation Inc · Wilmington, DEN41EKPrairie View Energy II LLC · Granite Falls, MNN41ERDeiulio Michael · Carle Place, NYN41EXFox James R · Saint Paul, MNN41FAKingsky Flight Academy LLC · Lakeland, FLN41FROplnet LLC · Arlington, VAN41GCmg Helicopters LLC · Summerfield, LAN41GBBoeing Co · Berkeley, MON41GCAviation Of North Florida LLC · Jacksonville, FLN41GDValiair Lc Trustee · Casper, WYN41GLGiegler Adam J · Cypress, TXN41GSGolf Sierra LLC · West Palm Beach, FLN41GVRbs Inc · Wht Sphr Spgs, WVN41HCDkh Air LLC · Shady Shores, TXN41HDHerman Edward G · Pitkin, CON41HMSale Reported · Reno, NVSale reportedN41HRTw Aviation LLC · Missoula, MTN41HSStevens Randall L · Abilene, TXN41HTJacobs Gregory R · Pinole, CAN41HYWillcutts William D · Greeley, CON41JAJersey Aero Club · Lakewood, NJN41JMAmerican Aviation Automotive Enterprises LLC · Lewes, DEN41JRDarnall Jeffery D · Jacksonville, FLN41KFThomas Wayne · Powell, OHN41KKDale Aviation LLC · Wilmington, DEN41LPulliam Oscar E Jr · Moscow, TNN41LACathriner Richard J · Plano, TXN41LCBowen William A III · California, MDN41LDThomas James A · Yukon, OKN41LLNotjets LLC · Paradise Valley, AZN41LSGendron Chistofer P · Prospect Park, PAN41LYFedflyt LLC · Russell Springs, KYN41MCGarner John B · Newark, DEN41MEFlydreams Aircraft Group Inc · Fort Lauderdale, FLN41MMRiester Robbin W · Navarre, FLN41MQParsons Douglas L · Carrollton, OH
Back to AD 2007-04-19 R1