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.
N45261Collins Paul C · Boise, IDN4526AMathews William A · Albuquerque, NMN4526BMorris Scott W · Livermore, CAN4526FReabe Spraying Service Inc · Plover, WIN4526JMcallister Aviation LLC · Richmond Hill, GAN4526LHeider Timothy Robert · Portland, ORN4526NButler Milton Forest · Oxford, GAN4526RGulledge Richard · Deland, FLN4526TBoal Ronald O · Mooresburg, TNN4526XGeorge Barbara A · Carlisle, PAN4526ZArmstrong Brandon M · Sierra Vista, AZN45277Fritz Kurt C · Montoursville, PAN45278Becker Air LLC · Stratford, CTN4527AMacking Craig P · Sepulveda, CAN4527HStewart Thomas D · Cashmere, WAN4527JRegistration Pending · Cedar Hill, TXRegistration pendingN4527LSchramm Harold · Utica, SDN4527NTobin Dwight B · New York, NYN4527RGmk Aviation LLC · Brighton, MIN45286Isley Phillip A · Anchorage, AKN4528FPhoenix Aviation Solutions LLC · Clarksville, TNN4528GBokoskie Isaac J · Kearney, NEN4528NPayne Craig Andrew · Discovery Bay, CAN4528RPhilbrick William E · Virginia Beach, VAN4528XChandler Agricultural Ind LLC Series Avation · Montgomery, ALN4529ACoffey County Airport · Burlington, KSN4529BCianfaglione Peter W · Madison, ALN4529DMakowiecki Maciej Piotr · Woodland Hills, CAN4529HPayne William C · Duluth, MNN4529LHopkins Josh · Corpus Christi, TXN4529NJames Douglas Z · Coudersport, PAN4529RSulzby Ivan Gerardo · Las Vegas, NVN4529YCunningham David L · Phoenix, AZN4529ZDaigle Michael R · Andover, NHN452AKSalo Mark W · Poulsbo, WAN452CBCyrus Richard W · Salisbury, MDN452CTMain Rotor Enterprises Llp · Scottsville, KYN452JPBrushpopper Aviation LLC · Annona, TXN452SPhantom Aviation LLC · Portland, ORN452WWilder Scott J · Orinda, CAN452WBDemark Aviation Inc · Wilmington, DEN45304Unruh Gerald R · Nampa, IDN4530DMccauley Terry D · Rogers, ARN4530EAig Aeronautics LLC · San Juan, PRN4530HJed Aire Aviation LLC · Benson, MNN4530SMontague Ronnie L · French Camp, MSN4530TKoprivnik Anton J · Painesville, OHN4530VSaunders Christopher D · Lehighton, PAN4530ZKirby Andrew P · Strattanville, PAN45312Heap Agriculture Service LLC · Stronghurst, IL
Back to AD 90-04-06 R1