AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N427EMBundy Edward · Eagle, IDN427EPChristiansen Aviation LLC · Wilmington, DEN427GKToal Timothy R · Milan, ILN427HKerr Kevin · Spring Hill, FLN427JCKad Enterprises LLC · Everett, WAN427JGLigon Scott A · Florence, ALN427KSchiavone John Anthony · Potomac, MDN427KSJagged Ridge Imaging LLC · Bainbridge Island, WAN427RDHeuerman Jordan Dale · Casey, ILN427RMWingsleasing LLC · Wichita, KSN427RSMadden James C · Salt Lake City, UTN427SBN16rn LLC · Lakewood, CON427SCJones Jeffrey A · Brooksville, FLN427SDBanning Keith K · Helena, MTN427SFN427sf LLC · Lakeview, NCN427WBColeman Steven R · Fernandina Beach, FLN428Kurtz Daniel · Circleville, OHN4280FRt Flyers LLC · Shakopee, MNN4280JWebberley Jason D · Kelso, WAN4280MCape May Aerial Advertising LLC · Cape May Ch, NJN4280ZKamlowsky Scott A · Anchorage, AKN42811Harris Patrick · Lincoln, CAN42812Skylink Aviation Inc · Florissant, MON4281HWilliams Wendell B · Anchorage, AKN4281JLewis Mark · Ozark, ALN4281QMcdonald Air Services LLC · Saint Johns, MIN4281TTheodorakis Alkeviades S · Fort Pierce, FLN4282JDill Tharold J Jr · Boron, CAN4282MGlave William C · Deltaville, VAN4282QShirley Walter Allen · Bullhead City, AZN4282THudson John P III · Grapeland, TXN4283HRubbert Jan D · Upham, NDN4283JBennett Tim M · Cambridge, OHN4283MDavis Roger · Dover, PAN4283SHayes Timothy · Gray, MEN4283TDziak Chester · Jackson, MIN4283ZHuseby Kelly E · Hulett, WYN4284LMorrison James J II · Grandview, TXN4284PEmpire Aviators LLC · Long Island City, NYN4284TOsborne Thomas A · Bloomington, INN4284ZBolin Matthew R · Everett, WAN4285HPralle Jeffory K · Wasilla, AKN4285QShielded Holdings LLC · Katy, TXN4285TBuenger Michael · Gilbert, AZN4285ZYoseph Barry L · Olympia, WAN428663 Elm Terrace LLC · Waterville, MEN42867Burns Charles R · Huntsville, ALN4286PGress Gabrielle M · Davenport, FLN4286ZMalcolm Rodgers K Jr · Belzoni, MSN42873Reyburn Steven T · Kokomo, IN
Back to AD 90-04-06 R1