Skip to content

Registered aircraft · 806

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:93-24-02-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:93-24-02-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:93-24-02-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:93-24-02-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:93-24-02-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:93-24-02-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.

N83CACheyenne 2 LLC · Colonial Heights, VABuilt 1980 · S/N 31T-8020072 N83MGWatkins Jon Trustee · Florence, ORBuilt 1981 · S/N 31T-8104047 N83PAHill Enterprise Inc · Wilmington, DEBuilt 1981 · S/N 31-8112050 N843DBDoan Creek LLC · Walla Walla, WABuilt 1978 · S/N 31T-7820090 N847Ultimate Resort Vacations Inc · Weston, FLBuilt 1977 · S/N 31-7812020 N849DWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 317952070 N862ARLe Pichon II LLC · San Juan, PRBuilt 1982 · S/N 31-8212019 N868ETSale Reported · Eagle OranjestadSale reportedBuilt 1973 · S/N 31-7305063 N86VADe Leon Inc · Perth Amboy, NJS/N 31-7952020 N879CSAviatzone LLC · Fort Lauderdale, FLS/N 31-7712033 N880RCPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 1973 · S/N 31-7305022 N885HAFox Airways LLC · Wasilla, AKS/N 31-7405416 N888JJGst Inmotion LLC · Kalispell, MTBuilt 1978 · S/N 317852078 N888LMAir Mods And Repair · Robbinsville, NJS/N 31-7405464 N888PCAirmonarc LLC · Orlando, FLBuilt 1981 · S/N 31-8152086 N888YAAds-B Technologies LLC · Anchorage, AKS/N 31-7305076 N88KJLegal Air LLC · Charleston, WVS/N 31-7912077 N88TGMakushin Logistics LLC · Fairbanks, AKBuilt 1984 · S/N 31-8452020 N88TLAh Legacy LLC · Orlando, FLBuilt 1980 · S/N 31-8152066 N88ZMFlorida Aero Services Sales Division Inc · Brandon, FLBuilt 1976 · S/N 31-7752016 N890HMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052194 N891CBKal-1 LLC · Wichita, KSBuilt 1980 · S/N 31-8012064 N892MMWings Of Dubuque LLC · Dubuque, IABuilt 1980 · S/N 31-8112029 N892TGTeo Steel Inc · Ramer, TNBuilt 1980 · S/N 31-8012053 N892TWTeo Steel Inc · Ramer, TNBuilt 1978 · S/N 31-7812111 N893CBAec Navajo LLC · Wilmington, DES/N 31-8012007 N89JASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 31T7920030 N900CGMarc Inc · Bolton, MSBuilt 1975 · S/N 31-7612002 N900PTGoblirsch Randy J · Sleepy Eye, MNBuilt 1973 · S/N 31P-7400176 N901TKAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 31T-7904028 N904SCMedical Disposables Corp · Orlando, FLBuilt 1981 · S/N 31-8152194 N905TJWhittington Peter M · Jupiter, FLS/N 31-7952204 N90APDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 31P-7300148 N90FSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 31T-8020011 N90VMJ & B Leasing Inc · Springfield, MOBuilt 1981 · S/N 31T-8104031 N910AGCreative Marketing Associates Inc · Saint Petersburg, FLBuilt 1984 · S/N 31T-8004041 N910HGTiffin Aire Inc · Tiffin, OHS/N 31T-7400009 N910JPRegistered aircraftBuilt 1977 · S/N 31T-7820004 N913NCDeweese Michel J · Rockvale, TNBuilt 1981 · S/N 31T-8120044 N914ASRed Speakers LLC · Newark, DEBuilt 1981 · S/N 31T8104066 N9167YComanche Flyers Inc · Gig Harbor, WABuilt 1968 · S/N 31-220 N916RTAasjng LLC · Holdrege, NEBuilt 1981 · S/N 31T-8166041 N917TPAerial LLC · Kalispell, MTBuilt 1982 · S/N 31T8104068 N918FMAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 31T-7904025 N919BBAf Land Ventures LLC · Palm City, FLS/N 31-7852025 N91BPF3 Aviation LLC · Summerville, SCBuilt 1977 · S/N 31-7812034 N91PWAerial Imaging Inc · South Bend, INBuilt 1976 · S/N 31-7652102 N9202YRomeo Aviation Ltd · Canton, OHBuilt 1983 · S/N 31P-8414004 N9210YOswald Sean B Trustee · Reno, NVBuilt 1983 · S/N 31P-8414007 N9212YS & B Foundation Air LLC · Auburn, ALBuilt 1983 · S/N 31P-8414008

Back to AD 93-24-02 R1