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.

N7198YDynamic Avlease Inc · Bridgewater, VABuilt 1972 · S/N LU-02 N7199DDynamic Avlease Inc · Bridgewater, VABuilt 1972 · S/N LU-06 N7199HDynamic Avlease Inc · Bridgewater, VABuilt 1971 · S/N LU-07 N7199LDynamic Avlease Inc · Bridgewater, VABuilt 1971 · S/N LU-09 N7199SDynamic Avlease Inc · Bridgewater, VABuilt 1972 · S/N LU-11 N719PBGraber Joel · Collins, MSBuilt 1973 · S/N LJ-594 N71KACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LJ-578 N71WBEagle Air Transport Inc · Ottawa, ILBuilt 1974 · S/N LW-127 N720COscar Charlie LLC · California, MDBuilt 1973 · S/N B-171 N722VBCopacetic Air LLC · Rutledge, TNS/N LJ987 N7230HAb Aviation LLC · Johns Island, SCBuilt 1985 · S/N LJ-1113 N725ARTrr Land & Livestock LLC · Douglas, WYBuilt 1979 · S/N LJ-879 N727MTKryptonite Industries LLC · Golden, COBuilt 1978 · S/N LW-271 N72JDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-72 N72LDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-19 N735KSouth Seattle Community College · Seattle, WABuilt 1965 · S/N LJ-35 N73MCCoastal Helicopters LLC · La Verne, CABuilt 1973 · S/N LJ-600 N73PHBronson Air LLC · Thebes, ILBuilt 1979 · S/N LJ-875 N747EMSal Holdings LLC · Helena, MTBuilt 1983 · S/N BE-136 N747VWHammer Aviation LLC · Miami, FLBuilt 1967 · S/N LD-360 N74JVAdvanced Avionics LLC · Cookeville, TNBuilt 1971 · S/N B-74 N7502NBemidji Aviation Services Inc · Bemidji, MNS/N LD-391 N750RCLuke & Payton LLC · Marianna, ARS/N LJ-640 N751KCJ A Peterson Enterprises Inc · Shawnee Mission, KSBuilt 1980 · S/N LJ-887 N754TWCentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-754 N757BAWw Air LLC · Burwell, NEBuilt 1984 · S/N LJ-1097 N758KCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ316 N75GDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-83 N75LW4t Aviation LLC · Maypearl, TXBuilt 1973 · S/N LW-75 N75NDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-57 N75RSCentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-533 N75VDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-103 N75ZDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-61 N761KCentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-426 N767MCMonument Aviation LLC · North Chesterfield, VABuilt 1973 · S/N LJ-595 N76GMDodson International Parts Inc · Rantoul, KSS/N LJ-498 N76QDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-15 N76RTEmax LLC · Perry, GABuilt 1970 · S/N LB-27 N770ABAgb Management Inc · Warrenton, VABuilt 1981 · S/N BE121 N770DReynolds Roger David · Key West, FLBuilt 1980 · S/N BE-90 N771CWJ&R Aviation Holdings LLC · Tampa, FLBuilt 1978 · S/N BE-52 N771PADodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N LJ-1055 N773PWTexair LLC · Hereford, TXBuilt 1979 · S/N LJ-864 N775DMGeneration Jets LLC · Denison, TXBuilt 1978 · S/N LJ-764 N776LDodson International Parts Inc · Rantoul, KSBuilt 1970 · S/N B-54 N777EB7eb Aviation LLC · Dallas, TXBuilt 1979 · S/N LJ-863 N777KATake-Off LLC · Knoxville, TNBuilt 1978 · S/N LW-285 N77CESmall Plane LLC · Carson City, NVBuilt 1978 · S/N LW-257 N77HEDavis Aviation Inc · Brandon, MSBuilt 1981 · S/N LJ969 N77NBDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N LJ818

Back to AD 81-23-01 R1