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.

N526RRDaytona Hot Cars Inc · Port Orange, FLBuilt 1967 · S/N LJ-263N53ECBas Part Sales LLC · Greeley, COBuilt 1972 · S/N LJ552N546CNCwn LLC · Wilmington, DEBuilt 1974 · S/N LJ609N549BRCentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N LJ-809N552BSBroken Arrow Crop Insurance Inc · Perryton, TXBuilt 1979 · S/N LJ-836N55MNMinnesota Department Of Transportation · Saint Paul, MNBuilt 1981 · S/N LJ-974N55WFIcm Inc · Colwich, KSBuilt 1985 · S/N LJ-1114N569EREastside Rice LLC · Jonesboro, ARBuilt 1981 · S/N LJ-944N5727Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B-48N575CLilly David E · Allentown, PABuilt 1971 · S/N LJ-532N577DCentral Virginia Aviation Inc · North Dinwiddie, VAS/N B-22N579PSFoxtrot Charlie Inc · Grass Valley, CABuilt 1970 · S/N LJ-496N57AGMonument Aviation LLC · North Chesterfield, VABuilt 1968 · S/N LJ-343N580RAGibson & Harrup Leasing LLC · North Dinwiddie, VABuilt 1973 · S/N LJ-580N590SHAlliance Air Parts Acquistions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 1977 · S/N LJ-753N599BB3gs Air LLC · Fort Myers, FLBuilt 1976 · S/N LJ-699N59KAParagon Office Services LLC · Dallas, TXS/N LJ-589N5TADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N LJ-724N600BFCentral Virginia Aviation Inc · Petersburg, VABuilt 1966 · S/N LJ-193N601DMR & G Aviation LLC · Hazlehurst, GABuilt 1979 · S/N LJ825N603PACentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-403N606PC988sl Aviation LLC · Ridgeland, MSBuilt 1980 · S/N LJ-938N608FBVortex Education Management LLC · El Cajon, CABuilt 1979 · S/N LJ-878N615AASkydive San Joaquin Valley Inc · Bakersfield, CABuilt 1967 · S/N LJ-298N6207FAir New England LLC · Portsmouth, NHBuilt 1982 · S/N LJ-1017N620WESouthwest Aviation Inc · Marshall, MNBuilt 1977 · S/N LJ-743N623BBAirshares Incorp · Petersburg, VABuilt 1967 · S/N LJ-277N640RJMidwest Executive LLC · Reno, NVBuilt 1985 · S/N LJ-1106N642TDN642td LLC · Newark, DEBuilt 1978 · S/N LJ-766N644JCBic Aviation LLC · Fort Smith, ARS/N LJ-698N6492CSouth River Services LLC · Myrtle Beach, SCBuilt 1982 · S/N LJ-1050N64KAXin Han Aviation LLC · Helena, MTBuilt 1973 · S/N LJ-606N6563KBeech Transportation Inc · Eden Prairie, MNBuilt 1982 · S/N LJ-1032N65TADodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-538N665JKSprinklermatic Florida LLC · Davie, FLBuilt 1975 · S/N LJ665N6681SN6681s LLC · Helena, MTBuilt 1979 · S/N LJ-850N6692DWisodak Air LLC · Eau Claire, WIBuilt 1984 · S/N LJ-1072N66ADRed Light Skydiving LLC · Jackson, MIBuilt 1968 · S/N LJ-380N66GSMile Hi Skydivers Inc · Longmont, COS/N LJ-237N66KAMullins Michael · Seaford, DES/N LJ-582N671LLCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1966 · S/N LJ-148N6723YKair Air LLC · Marietta, GABuilt 1982 · S/N LJ-1013N6754HAviation Communication And Surveillance Systems · Phoenix, AZBuilt 1980 · S/N LJ-891N6763KAla Ark LLC · Germantown, TNBuilt 1984 · S/N LJ-1064N682KALott Dalton Leon · Duncanville, TXS/N LJ-682N683MG1976 King LLC · Scottsdale, AZBuilt 1976 · S/N LJ-683N68CDSkydive Myrtle Beach Inc · Southport, NCBuilt 1968 · S/N LJ-366N6KZDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N LJ-238N700WWAces Full Inc · Deadwood, SDBuilt 1985 · S/N LJ-653N701XPFlight Partners 2 LLC · Lincoln, NEBuilt 1979 · S/N LJ-826
Back to AD 85-01-01