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.
N6148LYoukey John N · Yuma, AZN6148NAll-In-Aviation LLC · Paragould, ARN6148VChupp Aaron · Gallipolis, OHN6148WAir Ventures Flying School LLC · Smithfield, RIN6149Witek Edward G · El Cajon, CAN61494Millican Marc J · Anchorage, AKN614973 Dudes 1 Plane LLC · Olympia, WAN6149JAeroventures Flying Club Inc · Lilburn, GAN6149NZappa Tyler M · Hudson, FLN6149QGreen Airports Development Corp · Kemah, TXN6149TCrawford Iain A · Perkinsville, VTN6149VFoode Frank J · Cordova, AKN614ACLawless Aviation LLC · Fishers, INN614AZWienholt Robert Jr · Perry Hall, MDN614BGNorth Star Aviation Inc · Mankato, MNN614BLWingsleasing LLC · Wichita, KSN614BREsch Brian D · Colorado Springs, CON614CGC3 Aircraft LLC · Burnet, TXN614DHHall Wilburn H · Fort Payne, ALN614DPInternational Air Services Inc Trustee · Carson City, NVN614DVSpano David · Oswego, ILN614EDClark Richard A · Warren, MIN614FLEagle Sky Patrol Inc · Deadwood, SDN614GVVouga Greg M · Fuquay Varina, NCN614JDCc Aviation Inc · Tracy, CAN614JMLynch Bradley J · Fenton, MON614JTPorter Scott · Aguila, AZN614KDDixon Kenneth P · Arvada, CON614MMoonbeam Management LLC · Longwood, FLN614MATwinair LLC · Junction City, WIN614MTTrivundza Marko R · Saint Louis, MON614PSAeronaut Technolgy LLC · Jacksonville, FLN614PWAlpha Victor 8 LLC · Broken Arrow, OKN614RSecker David · San Jose, CAFirst renewal noticeN614RFBerry Charles P · Monroe, NCN614RGLittle Shiz Llcr LLC · Kalispell, MTN614SCRunamuck LLC · New Orleans, LAN614TVDurmisevich Dean J · Carnation, WAN614VZVision Aircraft LLC · Scottsdale, AZN614WTJamestown Jet Center Inc · Jamestown, NDN6150DPayne David J · Eagle River, AKN6150FFranklin Aviation LLC · Paradise, CAN6150JCypress Aviation LLC · Malvern, PAN6150LRucks Chad W · Okeechobee, FLN6150MJprg Aviation Inc DBA · Orlando, FLN6150RChristy David L DBA · Meriden, KSN6151HFly Aviation Corp · Wilmington, DEN6151ZRotor And Wing LLC · Tioga, NDN61526Mata Joseph F · E Setauket, NYN6152DFort Wolters Helicopter Inc · Mineral Wells, TX
Back to AD 90-04-06 R1