Registered aircraft · 5,102

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-12-06-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-12-06-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-12-06-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-12-06-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-12-06-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-12-06-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.

N761RBBastin Robet J · Cadiz, KYBuilt 1999 · S/N 3257107 N7622FAeronation Aircraft & Exotics LLC · Lewes, DES/N 32R-7780065 N7629VMountain Air Spray Co · Craig, COBuilt 1967 · S/N 1357 N762JMPridgen Michael E · Odenton, MDBuilt 1978 · S/N 32R-7887128 N762SASua 762sa Inc · Palm City, FLBuilt 1979 · S/N 31-7912042 N7638FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 32-7740014 N7639FArrona David M · San Luis Obispo, CABuilt 1976 · S/N 32R-7780068 N763RCL'Hommecourt Charles John · Ballston Spa, NYBuilt 1993 · S/N 27-0160 N7648VMiller Jerold R · Deering, NDBuilt 1968 · S/N 1376 N7649VBoeing Co · Renton, WABuilt 1968 · S/N 1428 N764JBLance Aviation Inc · Lakeland, FLBuilt 1976 · S/N 32R-7680506 N765Moby Partnership · Albuquerque, NMBuilt 1975 · S/N 61P-0271-057 N7651HGosbrook Aviation LLC · Lewes, DEBuilt 1973 · S/N 32-7440025 N7655FShining Star Aviation LLC · Zephyr Cove, NVBuilt 1976 · S/N 32-7740015 N765KPMarc Inc · Bolton, MSBuilt 1982 · S/N 31-8253012 N765LMLangdon Adam · Omaha, NEBuilt 1999 · S/N 27-0269 N7669VYpma Gene A · Harrison, MTBuilt 1968 · S/N 1397 N766CFAirplane Five LLC · Miami, FLBuilt 1973 · S/N 31-7305102 N766VKWave Golf LLC · Kimberly, ALBuilt 1977 · S/N 32R-7780271 N7671FPedal Valves Inc · Luling, LABuilt 1976 · S/N 32-7740016 N7678VHinckley David D · Belton, TXBuilt 1968 · S/N 1406 N767CVNcv LLC · Jacksonville, FLBuilt 2001 · S/N 3257234 N767RJS&S Aircraft Inc · Bennington, VTBuilt 1964 · S/N 27-2651 N767SCClegg Stephen A · Port Orange, FLBuilt 1977 · S/N 27-7754060 N7688Jte Properties LLC · Azle, TXBuilt 1996 · S/N 4636055 N768PEMts Inc · Middletown, DEBuilt 1977 · S/N 31-7712037 N7692FCwh Properties LLC · Falls City, NES/N 32R-7780080 N7694LLowell Darryl S · Anchorage, AKBuilt 1973 · S/N 31-7305024 N7696VBoeing Co · Renton, WABuilt 1968 · S/N 1424 N7698C98charlie LLC · Van Wert, OHBuilt 1975 · S/N 32R-7680059 N769GSSkylar Aviation LLC · Hagerhill, KYBuilt 1977 · S/N 32R-7780236 N769LZMontana 1204 LLC · Rock Valley, IABuilt 2003 · S/N 3255012 N76AWPacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554100 N76EHMitchell Matthew J · Penn Yan, NYBuilt 1975 · S/N 32R-7680034 N76FR76 Freedom LLC · Greenville, INBuilt 1977 · S/N 32R-7780317 N76JNGross Charles C III · Mims, FLBuilt 1976 · S/N 31-7652176 N770BHFernando Baeza · Anthony, NMBuilt 2005 · S/N 27-0342 N770BKHorizon Dreams LLC · Homer, GABuilt 1969 · S/N 27-4296 N770KTInterprime Air Inc · Doral, FLBuilt 1975 · S/N 31-7552053 N7711MStauffer Michael S · Wichita Falls, TXBuilt 1965 · S/N 27-2936 N7712FRice Robert Dalton · Kerrville, TXBuilt 1976 · S/N 32R-7780082 N7716PWhite Donald R · La Ward, TXFirst renewal noticeBuilt 1962 · S/N 24-2929 N771LMBruntjen Eric · Decatur, ILBuilt 1982 · S/N 32R-8229044 N7729VNew England Soaring Tug LLC · Perkinsville, VTBuilt 1969 · S/N 1480 N772DLClik Services LLC · Forestdale, MABuilt 1981 · S/N 318152007 N772DSCharleston Aviation Inc · Charleston, ILBuilt 2002 · S/N 4636338 N772SDWallace Robert L II · Anderson, SCBuilt 1978 · S/N 32R-7887246 N7735PVickers Tim F · Huntingdon, TNBuilt 1961 · S/N 24-2949 N773HPFlorida Highway Patrol · Tallahassee, FLBuilt 2000 · S/N T20608180 N773JSRjb Aviation LLC · Newark, DEBuilt 1989 · S/N 4622073

Back to AD 81-12-06 R1