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.
N8693YPeregrine Aviation LLC · Winfield, ILN86948Guglietta Jon R · Harwinton, CTN8694DJunek John M · Leonardtown, MDN86950Dale Jane L · Willow, AKN86953Madden Russell · Graford, TXN86954Breaking Wind LLC · Alabaster, ALN86957Swan Creek Flying Club · Ayr, NDN86959Collum Aviation LLC · Milton, FLN8695YPurkinje Ltd LLC · Wilmington, DEN86968Crafted Enterprises LLC · Montrose, CON86969Sperry Sails Inc · Marion, MAN8696RSmokovitz Joseph M · Tecumseh, MIN8696VMoynahan Thomas F · Newnan, GAN86974Qualitair LLC Trustee · MichelstadtN86977Ajs Aviation Inc · Spring Hill, FLN8697EMaze Bryan · Tulare, CAN8697VFisher Kurt Adrian Trustee · San Luis Obispo, CAN86983Hanson Curtis J · Peyton, CON86985Thomas Lucas G · Beebe, ARN86986Nelson Michael R · Philip, SDN86989Webb Terry M · Montreal, MON8698CRichard Waldren LLC · Newberg, ORN8699Blake Rodney · Trophy Club, TXN8699DBohannon James A III · Waller, TXN8699RQuinn Michael P · Matthews, NCN869BCInter American University Of Puerto Rico · Bayamon, PRN869CPExecutive Flight Institute LLC · Murrieta, CAN869GAtp Aircraft 9 LLC · Wilmington, DEN869KF3 Aero LLC · New Lenox, ILFirst renewal noticeN869NEJohn Cox LLC · De Witt, NEN869RRCooper Billy P · Columbia, MSN869RVThwaits John Drew · Ashland, MAN869TASheeptick LLC · Conrad, MTN869TTDimond Joan M · Birch Run, MIN869WCSchofield Wayne D · Polson, MTN86ABAir Sailing Inc · Reno, NVN86AKBuss Bryce D · Homer, AKN86BJWings Over Texas Holdings LLC · Denton, TXN86BKBlue Raven Air LLC · Eagle River, AKN86BPMiller Jacob Gordon · Fountaintown, INN86BTTaylor Paul E · Hilo, HIN86CKFord Darin E · Colorado Springs, CON86CSWarnock Tony J · Mobile, ALN86CZHayes Kenya D · Pike Road, ALN86DPerry Richard Kevin · Titusville, FLN86DBMchugh John J · Camano Island, WAN86DJJakusz Donald G · Coppell, TXN86DMShine Dylan Patrick · Jupiter, FLN86DWWhidbey Flight Services LLC · Coupeville, WAN86ECParisi Mario · Grosse Ile, MI
Back to AD 90-04-06 R1