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.

N971AMHoefler Wayne F · Colorado Springs, COBuilt 1981 · S/N LJ-983 N973GACentral Virigina Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N LJ675 N975SPSky Power LLC · Albuquerque, NMBuilt 1977 · S/N LW-263 N977AAGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1972 · S/N LJ-555 N97DDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1970 · S/N LM-137 N97TDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-127 N980VCN980vc Corp · Wilmington, DEBuilt 1977 · S/N BE19 N9838ZN B B S LLC · Kansas City, KSFirst renewal noticeBuilt 1969 · S/N LJ-435 N984MAExtraordinary Air LLC · Greenville, SCBuilt 1980 · S/N LJ883 N987ABDirty Joe Aviation LLC · Windsor, CABuilt 1978 · S/N LW-269 N988SLInternational Services Management LLC · Heath, TXBuilt 1969 · S/N LJ-438 N98ARRyan Gordon Air LLC · Santa Ana, CABuilt 1979 · S/N LJ829 N98HFValiair Ltd Co Trustee · Casper, WYBuilt 1973 · S/N LW-89 N98PMTcp One LLC · Amarillo, TXBuilt 1974 · S/N LW-131 N98TACentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N BE-56 N990CBB & G Aircraft LLC · Flanders, NJBuilt 1994 · S/N LJ-1362 N990JMCounty Of Galveston · Dickinson, TXBuilt 1966 · S/N LM-17 N990LSK&A Advisors LLC · Wilmington, DEBuilt 1975 · S/N LJ-677 N999CZN999cz LLC · Milwaukee, WIBuilt 1969 · S/N U116 N999DZAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U70 N999ESGatewood Aviation LLC · Lakeway, TXBuilt 1973 · S/N LJ-612 N999SFN999sf LLC · Amarillo, TXBuilt 1972 · S/N LW-5 N99ACRejo Inc · Wilmington, DEBuilt 1974 · S/N LW-120 N99GDynamic Avlease Inc · Bridgewater, VAS/N LM-129 N99GHAlpine Aviation Inc · Provo, UTS/N U-112 N9HWMullins Michael · Seaford, DEBuilt 1969 · S/N LJ-459 N9UZCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 1974 · S/N LJ641 N9VCArocosta LLC · Coral Gables, FLBuilt 1978 · S/N LJ-763

Back to AD 81-23-01 R1