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.
N8607YMs Aero Inc · Lakeville, OHN8608DYoung Mike · Albany, CAN8608VBenter Neil W · Ambrose, NDN8609NBird Properties LLC · Roosevelt, UTN8609VRegistration Pending · Frontenac, MNRegistration pendingN860ACAri Ben Aviator Inc · Fort Pierce, FLN860CPChristiansen Aviation LLC · Wilmington, DEN860PARe Elite Aviation LLC · Hialeah, FLN860SASaint Clair Flight Academy Inc · Richmond, MIN860SCFf22 LLC · Scottsdale, AZN860SPRegistered aircraftN860TCNorth Star Aviation Inc · Mankato, MNN860UBoard Of Regents Of The University Of Oklahoma · Norman, OKN8610CRuss Robert P · Van, TXN8610NSkipper Donald J · Huntersville, NCN8610RTener Dean R · Lisbon, OHN8611VAlbright Harold R · Dubois, WYN8611YCragg Gordon E · Georgetown, TXN8612DPerry Leonard M · Soldotna, AKN8613DPerry Kenneth V · Katy, TXN8613VBoley Trevor T · Palmer, AKN8614CErdmann Adam C · Raseau, MNN8614YD&D Maintenance LLC · Etna Green, INN8615VCitabria N8615v LLC · Westminster, CON8615YUniversity Of Alaska Anchorage · Anchorage, AKN8616DFrancis Harvey B · Key West, FLN8616VPittman Michael · Goodridge, MNN8617DGrisham Michael H · Paulden, AZN8617HToutant Roland J · Woodstock, CTN8617YBurton David A · Pepperell, MAN86181Neel Bradley H · Lakeland, FLN86183J L Air LLC · Wilmington, DEN8618YGroup Aire II · Manitowoc, WIN86198Styer David B · Pendleton, ORN8619ACowboy Up Aviation LLC · Frenchglen, ORN8619DBenton Mark H · Sussex, WIN8619EHogan Daniel L · Chapel Hill, NCN8619VPlane Folks LLC · Tucson, AZN8619YNuse Aviation LLC · Hollidaysburg, PAN861ACGuglietta Glenn W · Payson, AZN861APKlein Edwin Andrew Bell · Grass Valley, CAN861CHPope James D · Lewiston, IDN861MMGiordano Matthew J Jr · Wilmington, DEN861PProfessional Training Aircraft LLC · Wilmington, DEN861PAParis Air Inc · Vero Beach, FLN8620CLrh Equipment LLC · Pendleton, ORN8620DMid Atlantic Air Museum · Reading, PAN8621DBrown Lonnie S · Lone Jack, MON8621EUpdraft Leasing LLC · Tea, SDN8621YParks Ashton · Pepperell, MA
Back to AD 90-04-06 R1