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.
N4896TVosler Dean S · Bay City, MIN4896VSouth Aero LLC · Albuquerque, NMN48972Pickett Matthew A DBA · Gig Harbor, WAN4897ESig Flights LLC · Hickory, NCN4897FGnl Aviation LLC · Weatherford, OKFirst renewal noticeN4897GWings Over Texas Holdings LLC · Denton, TXN4898BPrecon Inc · Anaheim, CAN4898FLima-001 LLC · Muscatine, IAN48990Hyldburg Aviation · Plymouth, MAN4899GJf Property Leasing Inc · Port Orchard, WAN4899LSweat Larry D · Meridian, IDN489ACKuza Flyers LLC · Rock Hill, SCN489ALHehl Adam D · Anchorage, AKN489BBBoatman John H Jr · Smyrna, TNN489BCAviation Services Inc · Barre, VTN489ERMenefee Scott A · Los Banos, CAN489JOrr Matthew W · Kirkland, WAN489JEChambless Mardre F II · Panama City, FLN489LARed Baron LLC · Middletown, DEN489PWsi Southwest Inc · Cliff, NMN489PFFleming Peter A · Santa Clarita, CAN489RSViage LLC · Boston, MAN489RVBoyter Wayne · Winston, ORN489TJUnknown Media LLC · Cape Canaveral, FLN48ARGacey Inc Trustee · Wilmington, DEN48BGWhitfill Mark J · Crockett, TXN48BKKrebs Brian G · Hartland, WIN48BRField Christopher R · Kingston, TNN48CEEssential Aviation Llcregistered · Hickory, KYN48CLSharp Wade L · Asheville, NCN48DXSomers Andrew · El Paso, TXN48EAHillbilly Air LLC · Wilmington, DEN48EBEbgineering Inc · Ocklawaha, FLN48ELRegistration Pending · Livermore, CARegistration pendingN48ERChess Group LLC · Minden, LAN48EVRichardson Mark E · Altus, OKN48GHYellowstone Aviation Inc · Jackson, WYN48GKAnderson Kirby L · Mcveytown, PAN48GWMajerle Steven A · Big Lake, AKN48HAFiack Daniel P · Sun Valley, IDN48HGJahn Glenn R · Torrance, CAN48HUMelair 6 LLC · Easton, MDN48HYStruble Anne D · Springville, UTN48JAJahawk Leasing LLC · Sugar Grove, ILN48JJTotten James C · Newark, NJN48JKKeahey Britt · Saint Joseph, LAN48JWLee William L · Jonesborough, TNN48KBRydberg Lawrence · Albuquerque, NMN48KSHolcomb Garry M · Point, TXN48MBCaddell Charles Thomas · Wadesboro, NC
Back to AD 90-04-06 R1