AD 85-01-01
Registered aircraft · 317
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:85-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-01-01')
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:85-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-01-01') 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.
N526RRDaytona Hot Cars Inc · Port Orange, FLN53ECBas Part Sales LLC · Greeley, CON546CNCwn LLC · Wilmington, DEN549BRCentral Virginia Aviation Inc · Petersburg, VAN552BSBroken Arrow Crop Insurance Inc · Perryton, TXN55MNMinnesota Department Of Transportation · Saint Paul, MNN55WFIcm Inc · Colwich, KSN569EREastside Rice LLC · Jonesboro, ARN5727Central Virginia Aviation Inc · North Dinwiddie, VAN575CLilly David E · Allentown, PAN577DCentral Virginia Aviation Inc · North Dinwiddie, VAN579PSFoxtrot Charlie Inc · Grass Valley, CAN57AGMonument Aviation LLC · North Chesterfield, VAN580RAGibson & Harrup Leasing LLC · North Dinwiddie, VAN590SHAlliance Air Parts Acquistions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedN599BB3gs Air LLC · Fort Myers, FLN59KAParagon Office Services LLC · Dallas, TXN5TADodson International Parts Inc · Rantoul, KSN600BFCentral Virginia Aviation Inc · Petersburg, VAN601DMR & G Aviation LLC · Hazlehurst, GAN603PACentral Virginia Aviation Inc · Petersburg, VAN606PC988sl Aviation LLC · Ridgeland, MSN608FBVortex Education Management LLC · El Cajon, CAN615AASkydive San Joaquin Valley Inc · Bakersfield, CAN6207FAir New England LLC · Portsmouth, NHN620WESouthwest Aviation Inc · Marshall, MNN623BBAirshares Incorp · Petersburg, VAN640RJMidwest Executive LLC · Reno, NVN642TDN642td LLC · Newark, DEN644JCBic Aviation LLC · Fort Smith, ARN6492CSouth River Services LLC · Myrtle Beach, SCN64KAXin Han Aviation LLC · Helena, MTN6563KBeech Transportation Inc · Eden Prairie, MNN65TADodson International Parts Inc · Rantoul, KSN665JKSprinklermatic Florida LLC · Davie, FLN6681SN6681s LLC · Helena, MTN6692DWisodak Air LLC · Eau Claire, WIN66ADRed Light Skydiving LLC · Jackson, MIN66GSMile Hi Skydivers Inc · Longmont, CON66KAMullins Michael · Seaford, DEN671LLCentral Virginia Aviation Inc · North Dinwiddie, VAN6723YKair Air LLC · Marietta, GAN6754HAviation Communication And Surveillance Systems · Phoenix, AZN6763KAla Ark LLC · Germantown, TNN682KALott Dalton Leon · Duncanville, TXN683MG1976 King LLC · Scottsdale, AZN68CDSkydive Myrtle Beach Inc · Southport, NCN6KZDodson International Parts Inc · Rantoul, KSN700WWAces Full Inc · Deadwood, SDN701XPFlight Partners 2 LLC · Lincoln, NE
Back to AD 85-01-01