Registered aircraft · 924

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:83-22-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:83-22-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:83-22-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:83-22-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:83-22-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:83-22-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.

N273RRJet Set Aircraft Inc · Van Nuys, CABuilt 1965 · S/N 27-3020 N27CYSale Reported · Hastings, FLSale reportedBuilt 1976 · S/N 27-7654118 N27FMGogoplex LLC · Wilmington, DEBuilt 1976 · S/N 27-7654087 N27HPTrinair Aviation LLC · Hampshire, ILBuilt 1962 · S/N 27-2034 N286DDKhag Aviation Inc · Woodbridge, NJS/N 27-7854019 N28WRN28wr LLC · Simpsonville, SCBuilt 1971 · S/N 27-4626 N290MSurging Skyward Inc · Newtown, PAS/N 27-7554111 N291VPSeacrest Enterprises LLC · Asheville, NCS/N 27-8154025 N295SBChagres Aero LLC · Albuquerque, NMBuilt 1979 · S/N 27-7954091 N299RMGulf Atlantic Airways Inc · Gainesville, FLBuilt 1979 · S/N 27-8054024 N29AHRiseaero LLC · Florence, SCS/N 27-398 N2FXPlane Crazy Aviation LLC · Hollywood, SCBuilt 1966 · S/N 27-3147 N2HRWertheim Michael S · Fort Pierce, FLBuilt 1974 · S/N 27-7405342 N2QWPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754126 N2RPFasken Frank Andrew · Paris, TXS/N 27-7754160 N301SWFly Rite Aviation LLC · Fort Myers, FLS/N 27-195 N3086HGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 27-7754144 N30CPSkyveris LLC · Simi Valley, CABuilt 1973 · S/N 27-7305022 N311BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3313 N311JEJps Aviation LLC · West Chicago, ILS/N 27-7754053 N315NYPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754031 N317PZFairmont State University · Fairmont, WVBuilt 1980 · S/N 27-8054047 N318RHN72jp Inc · Annandale, VABuilt 1976 · S/N 27-7654184 N31DEBarber Deans Elliott III · Selma, ALBuilt 1961 · S/N 27-504 N31FACarlisle Robert · Pensacola, FLBuilt 1960 · S/N 27-215 N31RCJoey Os LLC · Darlington, PAS/N 27-2818 N31TUKalm Air Inc · Junction, TXBuilt 1973 · S/N 27-7305011 N31TVCornea Kevin Troy · Palm City, FLBuilt 1979 · S/N 27-7954054 N320RBLogan David J · Saint Helens, ORBuilt 1963 · S/N 27-2389 N321ACB & H Aviation LLC · Marion, KYBuilt 1974 · S/N 27-7405334 N321CCMclaughlin Ralph B · Groveland, CAS/N 277304950 N321NCArizona Air Salvage · Phoenix, AZBuilt 1977 · S/N 27-7754101 N322SMShivers James C II · Columbus, OHS/N 27-4417 N3234LTarrant County College · Fort Worth, TXBuilt 1967 · S/N 27-3626 N324RTTorres Rafael · Levittown, PRBuilt 1966 · S/N 27-3210 N325LBGlobal Aircraft Trust Inc Trustee · Cheyenne, WYS/N 27-7305149 N3278YMiddle Tennessee State University · Murfreesboro, TNS/N 27-3714 N329SDAce Flight Center Inc · St Thomas, VIBuilt 1966 · S/N 27-3512 N32JDDuflo Spray Chemical Inc · Bremen, NYS/N 27-372 N32RWSkylens LLC · Hammond, LABuilt 1971 · S/N 27-4667 N333FSAerodrome LLC · Louisville, KYBuilt 1969 · S/N 27-4456 N333JDDouglas Aero Inc · Fort Lauderdale, FLBuilt 1980 · S/N 27-8054016 N333PBBourne Hoppe & Associates LLC · Midland, MIBuilt 1975 · S/N 27-7654013 N333VAXrrx Inc · Wilmington, DEBuilt 1978 · S/N 27-7854099 N338SSSieli Paul III · Griffin, GAS/N 27-224 N339CTPatel Niral G · Atlanta, GABuilt 1974 · S/N 27-7405350 N33SAMcwherter Holdings Inc · Asheboro, NCS/N 27-3370 N341CHAce Flight Center Inc · St Thomas, VIBuilt 1980 · S/N 27-8154006 N3494AWheeler Michael R · Peculiar, MOBuilt 1962 · S/N 27-2197 N349CHAce Flight Center Inc · St Thomas, VIBuilt 1968 · S/N 27-3949

Back to AD 83-22-01 R1