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.
N4266QMaxwell James B · Lewiston, IDN4266ZVan Ryzin Chris K · Sterling, AKN42671P&N Corp · Marion, IAN42672Dowden Lairon W Jr · Nederland, TXN42673Chase Donald C · Erie, PAN42675908 Flying Club Inc · Fort Pierce, FLN42677Swank And Son Inc · Poplar, MTN42678Merow Michael C · Algoma, WIN4267HGmt Enterprises LLC · Stephenville, TXFirst renewal noticeN4267QDhf LLC · Valentine, NEN4267THooley Charles M · North Oaks, MNN42687Cal Coast Reps Inc · Costa Mesa, CAN42689Alc Aviation LLC · Waseca, MNN4268FWindt Edward A Jr · Chester, NJN4268JLuxair LLC · Van Nuys, CAN4268PAhlem Mark · Hilmar, CAN42693Paul D Barkhurst Pc · San Antonio, TXN42694Jaffa Bruce E · Moose Pass, AKN42698Bruch Stein · Randolph, MNN4269BNortheast Aviation LLC · Bynum, TXN4269HSiniakin Michael K · East Brunswick, NJN4269JMasino John B Jr · Berlin, MDN4269TRegistration Pending · Las Vegas, NVRegistration pendingN4269UAero380 Corp · Wilmington, DEN426ASSaylor Alvin N Jr · Friendswood, TXN426CPCivil Air Patrol · Montgomery, ALN426CTAir Kraft Aviation LLC · Timber Lake, SDN426CUMiller Justin S · Cedar Rapids, IAN426DDRare Air Aviation Services LLC · Santa Rosa, CAN426DLHawk30 Aviation LLC · Wilmington, DEN426ESWeaver Corey E · Saline, MIN426HHickerson Timothy William · Springfield, OHN426HLGiurtino Joel F · Spring Hill, FLN426JGAero Flight School No7 LLC · Lincoln Park, NJN426JKHuku 2 LLC · Princeton, NJN426JMThompson Daniel · Catawba, NCN426JTReilly Michael R · Vestal, NYN426KFFaris Kevin D · Plattsmouth, NEN426KXCoulman Michael A · Highland Village, TXN426LJVenture Air Solutions Inc · Opa Locka, FLN426LPAir Mates Flying Club Inc · Northfield, NJN426MBTimothy Harty · New Richmond, WIN426MCMagic Carpet LLC · Wilmington, DEN426NCHargrave Bobby P · Cantonment, FLN426PAN426pa LLC · New Orleans, LAN426PKMiddendorf Brian Jay · Alamogordo, NMN426PTWinter Livestock · Dodge City, KSN426PWElectron International Aviation LLC · Phoenix, AZN426RBChristiansen Aviation LLC · Wilmington, DEN426RCDahl Christopher E · Sutter Creek, CA
Back to AD 2007-04-19 R1