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.

N484MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 1978 · S/N LJ-807 N487JHCtgx Holdings LLC · Alpine, WYBuilt 1978 · S/N BE-43 N48AZStover Aviation LLC · Dallas, GABuilt 1979 · S/N LJ-859 N48WPlatina Investment Corporation · Oklahoma City, OKBuilt 1977 · S/N LW-254 N490DMFlying Colors Air Parts Inc · Leesburg, FLS/N LJ468 N4947MKca Of Montana LLC · Helena, MTBuilt 1978 · S/N LJ-780 N495NMCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N LJ-781 N499CZN499cz LLC · Milwaukee, WIBuilt 1969 · S/N U-81 N499LGear Robert Lee III · Paradise Valley, AZBuilt 1961 · S/N LC-87 N49JPSumner Properties LLC · Somersworth, NHBuilt 1990 · S/N LJ1243 N4RANyerges James · Midland, TXBuilt 1969 · S/N LB-4 N4RYCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1964 · S/N LJ-8 N500EQTxsd Holdings LLC · Amarillo, TXBuilt 1994 · S/N LJ-1387 N501MSDodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N LJ-626 N503CBCtb Inc · Goshen, INBuilt 1982 · S/N LJ-997 N504CBPlane Leasing LLC · Wilmington, DEBuilt 1974 · S/N LW-125 N504ECAlpha Tango LLC · Little River, SCBuilt 1995 · S/N BE-120 N50525Kansas State University · Salina, KSS/N LJ159 N505MWBoeing Co · Renton, WAS/N LW-155 N506AFCreedeair LLC · San Antonio, TXBuilt 1979 · S/N LJ-843 N5078EBemidji Aviation Services Inc · Bemidji, MNBuilt 1963 · S/N LF-76 N5078GFresh Air Aviation Inc · Charlevoix, MIBuilt 1960 · S/N LF-8 N5078NBemidji Aviation Services Inc · Bemidji, MNS/N LF-16 N5078UBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-32 N5079EBemidji Aviation Services Inc · Bemidji, MNS/N LF-52 N5080GQuinlan John H DBA · Claxton, GABuilt 1962 · S/N LF-35 N5080HBemidji Aviation Services Inc · Bemidji, MNBuilt 1961 · S/N LF-27 N5080LBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-59 N50EBDavis Aviation Inc · Brandon, MSBuilt 1975 · S/N LW-128 N5111PDe La Vega Artemio · Dallas, TXBuilt 1986 · S/N LJ-1136 N511WMD&D Industries Inc · Monclova, OHBuilt 1973 · S/N LW-57 N515GKAvintel Management LLC · Dublin, OHBuilt 1974 · S/N LW-108 N51685Midland Avionics LLC · Louisville, KYS/N LC-40 N519RRCgs 2003 LLC · San Leon, TXBuilt 1978 · S/N BE-40 N51DNDjl Investments LLC · Gilroy, CABuilt 1972 · S/N LW-7 N522MJPpr2 Inc · Jackson, MSS/N LW-80 N5245FAex Aviation LLC · Davenport, FLBuilt 1965 · S/N LJ-92 N526RRDaytona Hot Cars Inc · Port Orange, FLBuilt 1967 · S/N LJ-263 N527QSilver Linings Air And Farm LLC · Chamblee, GABuilt 1968 · S/N LC-284 N52KACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-42 N52VSVista Strategies & Solutions Group LLC · Hendersonville, NCS/N LW-301 N531CBSpectre Aviation LLC · Dover, DEBuilt 1983 · S/N BE-133 N533SSMacon King Air 90 LLC · Dover, DEBuilt 1976 · S/N LW-197 N53CEEngineering And Mfg Svcs Inc · Huntsville, ALBuilt 1975 · S/N LW-160 N53ECBas Part Sales LLC · Greeley, COBuilt 1972 · S/N LJ552 N53HSC&B Aerial Transport Inc · Wilmington, DEBuilt 1976 · S/N LW-186 N541MCDynamic Avlease Inc · Bridgewater, VAS/N LM-39 N5452WTechnical Education Services Inc · Virginia Beach, VABuilt 1965 · S/N LC-191 N546CNCwn LLC · Wilmington, DEBuilt 1974 · S/N LJ609 N549BRCentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N LJ-809

Back to AD 81-23-01 R1