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.
N4637WBrimmer Kyron · Encinitas, CAN46381Oldis Frank A · Taylors, SCN46382Cognition LLC · Billings, MTN46385R A Marsh Flying Club LLC · Williamson, GAN4638ATropical Air Lease LLC · Hialeah, FLN4638EMorelock Colleen P Trustee · Beavercreek, OHN4638FSkydive Lake Tahoe LLC · Tahoe City, CAN4638JChappel Dexter A · Palm Coast, FLN4638KWiggins Air Patrol LLC · Wichita, KSN4638VRegistration Pending · Olympia, WARegistration pendingN4638WHavens Todd · Airway Heights, WAN46390Gerber Aviation LLC · Winter Haven, FLN46391Stark Rickie N · Princeton, MNN46392Tedron Air Ltd · Setauket, NYN46396Kpa LLC · Kalamazoo, MIN46399Rutter Clarence W III Trustee · Norman, OKN4639BMoncrief Georgeanne H Trustee · Nampa, IDN4639KMyers Gary L Trustee · Onida, SDN4639QGrundmann Karl · Manassas, VAN4639RSterling Flight Training LLC · Jacksonville, FLN4639VRunway 7 LLC · Lewes, DEN4639WValiair Lc Trustee · Casper, WYN4639YRegistered aircraftN463AGAb Prop Plane II LLC · Metairie, LAN463CACivil Air Patrol · Maxwell Afb, ALN463CMUniversity Of Central Missouri · Warrensburg, MON463DGZhong Yu · Henderson, NVN463DMGresham Stanley W DBA · Ironwood, MIN463DSSalisbury David W · Gettysburg, PAN463FAStratus Rr LLC · New Castle, DEN463KNg Aviation LLC · Dover, DEN463MAnssec LLC · Lake In The Hills, ILN463PWDunlop Ronald K · Scottsdale, AZN463RNDave Aviation LLC · Naperville, ILN463SPRegistered aircraftN463TCheck 6 LLC · Spearfish, SDN463TWTom Wood Aviation Inc · Fishers, INN46401Bandstra Larry J · Heath Springs, SCN46404Coastal Fliers Inc · El Cajon, CAN46407Solis Joseph G · Poulsbo, WAN4640EState Of Utah · Salt Lake City, UTN4640FDouglas Mark S DBA · Bellingham, WAN4640GHonea Richard S · Canton, GAN4640J4 Flyers Inc · Norwood, NYN4640KLarson Family Farms LLC · Haxtun, CON4640RSchotter Robin J · Seattle, WAN4640VHbhis LLC · Gnadenhutten, OHN4640WBerger Adam · Kanab, UTN46410Valentine Terence · Glennallen, AKN46415Hage Michael J · The Villages, FL
Back to AD 2007-04-19 R1