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.
N6686LHartmann Peter F · Paulden, AZN6686RAnderson Benjamin P · Bellevue, NEN6686UNorstegaard Mark A · Sturgis, SDN6687CHurtt Ben J · Mountain Grove, MON6687JRio Creek Aviators Ltd · Casco, WIN6687WHolland William A · Brownwood, TXN66884Sea2ski Flying Club Inc · Anchorage, AKN6688RFarley Clayton · Hanford, CAN6688WArkansas Air Expeditions And Instruction LLC · Greenbrier, ARN66898Registration Pending · Haines, AKRegistration pendingN6689UStillman Troy C · Neenah, WIN6689WStoll Jared M · Burnt Hills, NYN668AMCenter Line Aviation Limited · Brookville, PAN668BNBelter Randolph K · Zachary, LAN668FBTexas Air Museum · Slaton, TXN668GWRholetter Wayne C · Westminster, SCN668LStarr Larry D · Gold Hill, NCN668PTCooper Michael T · Manson, IAN668QUnruly Passengers LLC · Piedmont, SCN668RFSass Roland Falk · Beale Afb, CAN668RVForester James C · Trenton, GAN66908Herman Timothy R · Presho, SDN6690DMiesko Martin A · Sprng Brk Twp, PAN6690JJones Michael A · Chateaugay, NYN6691LCoconut Adventures LLC · Lewes, DEN6691RSgt Land And Cattle Co LLC · Bennington, KSN6691USchleis Ralph F · Manitowoc, WIN6691WN6691w LLC · Nazareth, PAN66931Laguna Verde Leasing Inc · Wilmington, DEN6693HSwithenbank Leonard Co-Trustee · Fort Bragg, CAN6693JOgrady Thomas · Franklin Square, NYN6693UShapiro Kier I · Oxnard, CAN66941Blue Mountain Airways LLC · Woodstock, GAN66946Sunrise Aviation Inc · Ormond Beach, FLN66948Kuriger Michael R · Santa Clarita, CAN6694EThunderbird Aviation LLC · Littleton, CON6694JStegemoller Adam Dean · Lewisville, TXN6694RRegistered aircraftN6694UWilson Larry · Campbellsville, KYN6694WKhan Mohammed Sabir K · Sugar Land, TXN66954Wings Over Texas Holdings LLC · Denton, TXN6695JMorgan Jonathan · East Troy, WIN6695MRegistration Pending · Sheridan, WYRegistration pendingN6695RKepner Charles M · Shepherd, MIN6695WMeyers Chris · Andrews, TXN6696JTattersall Stewart Trustee · Minden, NVN6696UAtkinson Matthew D · Theodore, ALN66970California Airways LLC · Hayward, CAN66971Meridian Airport Authority · Meridian, MSN66977Unique Educational Experiences · Signal Hill, CA
Back to AD 90-04-06 R1