Skip to content

Registered aircraft · 728

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

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:81-23-01-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:81-23-01-R1') ORDER BY n_number

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:81-23-01-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:81-23-01-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:81-23-01-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:81-23-01-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.

N64KAXin Han Aviation LLC · Helena, MTBuilt 1973 · S/N LJ-606 N6558Metropolitan Airport Authority · Moline, ILS/N 85 N6563KBeech Transportation Inc · Eden Prairie, MNBuilt 1982 · S/N LJ-1032 N659Gulf South America Air Transport Inc · Mobile, ALS/N LC72 N65CSChallans Robert F · Hesston, KSS/N LC-82 N65MSSummey Aviation LLC · Asheville, NCS/N LW-202 N65QAGulf States Air Inc · Bossier City, LAS/N LC-165 N65TADodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-538 N65UDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-87 N65VDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-113 N662JSHughes Leasing Co · Miami, FLBuilt 1976 · S/N LW-176 N665JKN665jk LLC · Boca Raton, FLBuilt 1975 · S/N LJ665 N6681SN6681s LLC · Helena, MTBuilt 1979 · S/N LJ-850 N6692DWisodak Air LLC · Eau Claire, WIBuilt 1984 · S/N LJ-1072 N66ADRed Light Skydiving LLC · Jackson, MIBuilt 1968 · S/N LJ-380 N66GMEdge Logistics Inc · Southlake, TXBuilt 1969 · S/N LB-1 N66GSMile Hi Skydivers Inc · Longmont, COS/N LJ-237 N66KAMullins Michael · Seaford, DES/N LJ-582 N66WDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-68 N671LLCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1966 · S/N LJ-148 N6723YKair Air LLC · Marietta, GABuilt 1982 · S/N LJ-1013 N6754HAviation Communication And Surveillance Systems · Phoenix, AZBuilt 1980 · S/N LJ-891 N6763KAla Ark LLC · Germantown, TNBuilt 1984 · S/N LJ-1064 N677JHobbs Aircraft LLC · Waco, TXBuilt 1978 · S/N LW-294 N67BDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-59 N67KDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-24 N67VSouthall Properties LLC · Vicksburg, MSBuilt 1978 · S/N LW-306 N682KALott Dalton Leon · Duncanville, TXS/N LJ-682 N683MG1976 King LLC · Scottsdale, AZBuilt 1976 · S/N LJ-683 N686ACStm Air LLC · Ocala, FLBuilt 1981 · S/N BE-127 N6890QSoest Dean · Quartz Hill, CABuilt 1965 · S/N LD-224 N68CDSkydive Myrtle Beach Inc · Southport, NCBuilt 1968 · S/N LJ-366 N68MUPark Avenue Group Inc · Stuart, FLBuilt 1978 · S/N BE-37 N690GLathem Russell Glen · Dalhart, TXBuilt 1972 · S/N LW-34 N699ALBallard Aviation Inc · Newton, KSBuilt 1980 · S/N BE-83 N699CZN699cz LLC · Milwaukee, WIBuilt 1968 · S/N U-10 N6AQNyerges James · Midland, TXBuilt 1964 · S/N LD-214 N6KZDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N LJ-238 N7000BBeechcraft Heritage Museum Inc · Tullahoma, TNS/N LM-01 N7007GDynamic Aviation Group Inc · Bridgewater, VAS/N LM-02 N70088School Of Missionary Aviation Technology · Ionia, MIS/N LM-06 N700BAAviation Inventory Resources Inc · Alvarado, TXBuilt 1980 · S/N BE-84 N700DHGramer Air II LLC · Bloomfield Hills, MIBuilt 1974 · S/N LW-114 N700WWAces Full Inc · Deadwood, SDBuilt 1985 · S/N LJ-653 N7010LDynamic Aviation Group Inc · Bridgewater, VAS/N LM-07 N7014LDynamic Aviation Group Inc · Bridgewater, VAS/N LM-10 N7018FDynamic Aviation Group Inc · Bridgewater, VAS/N LM-13 N701NCNorth Country Aviation Inc · Gaylord, MIBuilt 1972 · S/N LW-18 N701XPFlight Partners 2 LLC · Lincoln, NEBuilt 1979 · S/N LJ-826 N70292Dynamic Aviation Group Inc · Bridgewater, VAS/N LM-18

Back to AD 81-23-01 R1