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.

N820JHHughes Leasing Co · Miami, FLBuilt 1981 · S/N 318152015 N824PGMount Olive Flight Club LLC · Mount Olive, NCBuilt 1982 · S/N 31-8252055 N827RDGoyo Air LLC · Miami, FLBuilt 1976 · S/N 31-7652094 N828HJPegasus Air Charter LLC · Hartford, CTBuilt 1980 · S/N 31-8052160 N828KTJones Larry · Anchorage, AKBuilt 1980 · S/N 318052098 N834NQAlaska Door LLC · Wasilla, AKBuilt 1977 · S/N 31-7752070 N83PAHill Enterprise Inc · Wilmington, DEBuilt 1981 · S/N 31-8112050 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 N900CGMarc Inc · Bolton, MSBuilt 1975 · S/N 31-7612002 N904SCMedical Disposables Corp · Orlando, FLBuilt 1981 · S/N 31-8152194 N905TJWhittington Peter M · Jupiter, FLS/N 31-7952204 N9167YComanche Flyers Inc · Gig Harbor, WABuilt 1968 · S/N 31-220 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 N9218YHubble Boeing Development Corp · Gallipolis, OHBuilt 1968 · S/N 31-282 N9247LGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 31-8152160 N926HBAwmr LLC · Conroe, TXBuilt 1975 · S/N 317552007 N92BLIsland Birds Inc · St Thomas, VIS/N 31-7852095 N931SAMarc Inc · Bolton, MSBuilt 1975 · S/N 317552036 N938PMD & B Aviation LLC · Stroudsburg, PABuilt 1983 · S/N 31-8452013 N942EAngry Manx LLC · Riverside, CABuilt 1975 · S/N 31-7552116 N949WAP S S Air Inc · Middlesboro, KYBuilt 1976 · S/N 31-7612069 N95KAAirborne Resources Inc · Midlothian, TXBuilt 1981 · S/N 318152146 N95TCMmec Air LLC · Oxford, MSBuilt 1983 · S/N 31-8352037 N961PAThiel Bros Roofing Inc · Sidney, MTBuilt 1975 · S/N 317652017 N96342Aircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1977 · S/N 31-7405205 N9680TK And K Recycling Inc · Fairbanks, AKBuilt 1970 · S/N 31689 N974CSMcgregor Daniel A · Denali Natl Park, AKBuilt 1976 · S/N 31-7652120

Back to AD 82-16-05 R1