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.
N8948YKilpatrick Kerry · Somerset, NJN89492Pilot Farm LLC · Grant, NEN8949CMorgan Aviation LLC · Greensboro, NCN8949JSchmidt Roger L · Plattsmouth, NEN8949RMorten Jesse L · Larimore, NDN8949ZBills Mark W · Willow, AKN894ACAri Ben Aviator Inc · Fort Pierce, FLN894ALLancaster Wesley A · Saint Augustine, FLN894CDSykes Richard D · Longmont, CON894FSMiller Dietrick J · Monte Vista, CON894MAHot Wings Aviation LLC · Indianapolis, INN894MJWaite Richard H · Sun Valley, IDN894RVCox Aaron D · Kalama, WAN894YPodunk Planes LLC · Boulder, CON895Ghosh Abhimanyu · Mojave, CAN89503Menne Aviation LLC · Brooklyn Park, MNN8950FAloft · Haiku, HIN8950MPacific Flight Academy LLC · Honolulu, HIN8950UManley Steven T · Dallas, TXN8951DChadwick Stewart · Yuba City, CAN8951JMoehle Colleen M · Lincoln, ILN8951LWoolslayer John P · Tulsa, OKN89531Glynco Manning Aviation Inc · Brunswick, GAN89533Ashby Shawn Alan · San Luis Obispo, CAN89539Jkg LLC · Murfreesboro, TNN8953DVassal Ministries · North Pole, AKN89549Jodkin Jason J · Confluence, PAFirst renewal noticeN8955YCarter Howard A III · Stafford, VAN8956Martini Philip D · Bethel Park, PAN8956CCosper Rodney S · Killeen, TXN8956JBays Bob D · Jasper, MON8956YDark Side Aeronautical Inc · Wilmington, DEN8957CTracon Aviation LLC · Winter Springs, FLN8957JAirplane LLC · Farmington, UTN8957VN8957v LLC · Fort Lauderdale, FLN8958English John H · Pittsburg, TXN89585Vinland Flight School LLC · Topeka, KSN89588Jet & Rotor Aviation LLC · Sacramento, CAN8958CWinter John T · Tucson, AZN8958DPoulton Daniel D · Belton, SCN8958JDavis William M · New Lenox, ILN8958LBarron John C · Tulsa, OKN8958VHyldburg Aviation Inc · Plymouth, MAN89594Executive Aviation LLC · Peoria, AZN8959CHanson Dan H · Lusk, WYN8959JRegistration Pending · Fairmont, WVRegistration pendingN895AGProffetty Stephen D · Bridgewater, MAN895DSGuida Associates Consulting Inc · Sandpoint, IDN895VSpurlock Ricky DBA · Jensen, UTN89600Philbrick Rodney C DBA · Bishop, CA
Back to AD 90-04-06 R1