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.
N69892D & S Ventures Ltd LLC · Haiku, HIN6989BHolzman Douglas S · White Salmon, WAN6989QHumphrey Bobby E · Dandridge, TNN6989RMoran Dennis E · Waverly, PAN6989VFussell James Vaulx V · Jackson, MSN6989WCarter Johnny W · Crawford, TXN698CHFranklin Ricky L · Glade Hill, VAN698CPSerodind Peterj · Chattanooga, TNN698FLNight Fox Aircraft LLC · Mesa, AZN698MBravo Zulu International Ltd · Las Vegas, NVN698SHMccair LLC · Mineral Wells, TXN698SPFoothill Aircraaft Sales & Service Inc · Upland, CAN6990BE T Wells Inc · Helena, ARN6990DHorn Paul · Kodiak, AKN6990KReeves Donald L · Harrison Township, MIN6990WMadichar LLC · Lempster, NHN6991HRhinelander Flying Service Inc · Palmetto, FLN6991KMoore Jeffrey D · Blossvale, NYN6991UHochstein Scott J · Skiatook, OKN6991WCarnes James Oscar Jr · Smiths Grove, KYN6992EMikkelsen John P · Sebastopol, CAN6992KGeser Ryan · Newberg, ORN6992RBanana River Aviation LLC · Merritt Island, FLN6993BFarneski Robert B · Fairbanks, AKN6993JCannon Maureen A · Wareham, MAFirst renewal noticeN6993KHudock Cody Jacob · Kill Devil Hills, NCN6993URamirez Arturo A · Lake Creek, TXN6994JLytle Tobin A · Grove, OKN6994KGarfield Joe · Morgan, UTN6994PHunt Ray A · Louisburg, NCN6994QGronewold Dale A · Gothenburg, NEN6994URegistered aircraftN6994VKroutil David W · Hilmar, CAN6994WCone Carl T · Statesboro, GAN6995BChase Kenneth W · Anvik, AKN6995CDetert Bradley · Valparaiso, INN6995DZimmerman Christian · Anchorage, AKN6995KShuey Kenny L · Neosho, MON6995RFeher Tara A · Chesapeake, VAN6995VHausmann Internaational Inc · Sugar Land, TXN6996BAafedt Aaron B · Belgrade, MTN6996DByrd David P · King Salmon, AKN6996HWeirich Gayle M · Rockford, MIN6996UHanrahan William P · Seward, AKN6996WGiles David · Augusta, GAN6997DM & M Farms · Fowler, KSN6997JBailey Kevin R · Crown Point, INN6997RTimmons Tracy · Jacksonville, ILN6997UDoull Leyla · Miami, FLN6997WKeeter Michael P · Proberta, CA
Back to AD 90-04-06 R1