Registered aircraft · 562

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:82-16-05-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:82-16-05-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:82-16-05-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:82-16-05-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:82-16-05-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:82-16-05-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.

N73RTRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N 31-8252023 N744JCAck-Pg-LLC · Charlestown, MABuilt 1979 · S/N 31-7912119 N747CGAir Americus LLC · Johns Creek, GABuilt 1981 · S/N 31-8152070 N74932Ruocco 220 LLC · Escondido, CABuilt 1973 · S/N 31-7305074 N74972H&H Aircraft LLC · Grey Eagle, MNBuilt 1973 · S/N 31-7305123 N74DDN74dd Inc · Apalachicola, FLBuilt 1978 · S/N 31-7952016 N74LKAlexander 3 Aviation LLC · Rincon, GAS/N 31-8012038 N74MJFord Richard M · Cartersville, GABuilt 1977 · S/N 31-7712065 N75LKN75lk LLC · Lafayette, LABuilt 1981 · S/N 31-8152173 N762SASua 762sa Inc · Palm City, FLBuilt 1979 · S/N 31-7912042 N765KPMarc Inc · Bolton, MSBuilt 1982 · S/N 31-8253012 N766CFAirplane Five LLC · Miami, FLBuilt 1973 · S/N 31-7305102 N7694LLowell Darryl S · Anchorage, AKBuilt 1973 · S/N 31-7305024 N76JNGross Charles C III · Mims, FLBuilt 1976 · S/N 31-7652176 N770KTInterprime Air Inc · Doral, FLBuilt 1975 · S/N 31-7552053 N772DLClik Services LLC · Forestdale, MABuilt 1981 · S/N 318152007 N774CERegistration Pending · Saint Paul, MNRegistration pendingS/N 31-7712047 N776WBcww LLC · Bakersfield, CABuilt 1980 · S/N 31-8052165 N777HZCb Auto Inc · Columbia, MDS/N 31-7405177 N777JYKingslyn Ltd · Wilmington, DEBuilt 1978 · S/N 31-7912004 N777MEDe La Garza De La Fuente Jose A · Montgomery, TXBuilt 1980 · S/N 31-8012049 N777VZFreeman Brooks · Richmond, VABuilt 1981 · S/N 31-8212012 N777ZMFriar Aerospace Group LLC · Dover, DEBuilt 1980 · S/N 31-8052193 N77DSBalderas Alberto · Harlingen, TXS/N 317812061 N780GCAir Eye Md LLC · Carolina, PRBuilt 1978 · S/N 317812069 N7827SStar Aviation Inc · Melville, NYBuilt 1982 · S/N 31-8252035 N783BZJsaz LLC · North Little Rock, ARS/N 31-7305018 N787RWJw Venture Aviation LLC · Concord, NCS/N 31-7652087 N78GHCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 31-7852121 N78MSDibenedetto Todd P · Riverwoods, ILS/N 31-7812074 N79LDTcb Aviation LLC · Evansville, INBuilt 1982 · S/N 31-8252062 N79LKGonzalez Leon · Pembroke Pines, FLBuilt 1980 · S/N 31-8012092 N800DKBartlett Paul H · Nebo, NCBuilt 1976 · S/N 31-7612110 N800LPC A Aviation Corp · Clifton, TXBuilt 1983 · S/N 31-8352009 N800MWNorpel Express LLC · New Bedford, MABuilt 1981 · S/N 31-8252011 N801CHRisse Greg L · Lincoln, CABuilt 1974 · S/N 31-7405460 N802GAMns Asset Management LLC · Dover, DEBuilt 1981 · S/N 31-8152103 N8033RGoodson Aviation LLC · Tallahassee, FLS/N 31-7952065 N805MMBlackburn Steven D · Palmetto Bay, FLS/N 31-7812108 N805NJFreedom Capital Air LLC · Winchester, TNBuilt 1980 · S/N 31-8052109 N8063MFriar Aerospace Group LLC · Jacksonville, FLBuilt 1978 · S/N 31-7852023 N807ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8152183 N808ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8052128 N80GVMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1975 · S/N 31-7552003 N80LKEti Aviation LLC · Boynton Beach, FLBuilt 1977 · S/N 31-7712103 N812TBTwin Aviation LLC · Coushatta, LABuilt 1981 · S/N 31-8152113 N8131Regional Air & Transport LLC · Mims, FLBuilt 1981 · S/N 31-8152032 N818BRMarc Inc · Bolton, MSBuilt 1981 · S/N 318152102 N81EDNav-Pete LLC · Memphis, TNBuilt 1979 · S/N 31-7952220 N820FSAir Arctic Inc · Fairbanks, AKBuilt 1979 · S/N 317952185

Back to AD 82-16-05 R1