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.
N6697DAtlanta Aviation Academy Inc · Lawrenceville, GAN6697JGlenn Larry W · Bunn, NCN6697RJ Bar Ranch LLC · Downey, IDN66985Reid Robert W III · Independence, ORN6698HNational Test Pilot School · Mojave, CAN6698QBrager Robert L · Oxnard, CAN6699Jcmc Inc · Junction City, KSN6699JRegistration Pending · Loup City, NERegistration pendingN6699LPierce Jeffrey D · Woodinville, WAN6699SBeach Coleen W · Moncks Corner, SCN6699UGuy Carlo A · Ramona, CAN669ALeppert James J · Dickey, NDN669AKRegistered aircraftN669AMForry Anthony · Athens, TNN669CEOne Pft LLC · Denton, MTN669DKBrunner Matthew W · Bellingham, WAN669KPClink Andrew D · Phoenix, AZN669NEAcme Aircraft Flying Club LLC · Kalispell, MTN669PMKohl Rex · Eden Prairie, MNN669RVN669rv LLC · New Albany, INN669RWRhodes Brian W · Valdez, AKN669SHulick Kent · Houston, TXN669SMClearance Clarence Aviation LLC · Hallsville, TXN669SNKajans Douglas L · Reno, NVN669TJBouyea John M · Hillsboro, ORN669UShartle Austin W · Fredericksburg, PAN669WBBailey Donnie W Jr · Tyronza, ARN669XDiehl Steven K · Homestead, FLN66AALift Aviation LLC · Kingston, MAN66AJPalmer Paul H · Minden, LAN66AKDomke Daniel C · Fairbanks, AKN66ALXin Han Aviation LLC · Atwater, CAN66APPeterson Alex A · Ottertail, MNN66AUSky West Aviation Inc Trustee · Albuquerque, NMN66AWSg Aviation Inc · Clearwater, FLN66AZVia International Inc · Reunion, FLN66BRPierce Stephan L · Graham, TXN66CDKcsi Aerial Patrol Inc · Bakersfield, CAN66CFFuller Leonard C · Mattawa, WAN66CMMadson Jerome R · Goodyear, AZN66CRRazer Chester R · Columbia, ILN66CVStinebring Brad L · Columbus, INN66DSPaulsen Rebecca D · Broken Arrow, OKN66EBAj Aviation Services LLC · Midland, TXN66FBJames W Woodward · Sagle, IDN66FTTill Robert B · Cody, WYN66FUGreen Steven D · Underhill, VTN66FWBracilano Robert A · Virginia Beach, VAN66GJShamrock Aviation LLC · Seabrook, NHN66GMEdge Logistics Inc · Southlake, TX
Back to AD 90-04-06 R1