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.

N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196 N100LYLyon Aviation Inc · Pittsfield, MAS/N 31-8052064 N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019 N100XRTomsis Corp · Panama City, FLBuilt 1981 · S/N 31-8152169 N101MAPablo Air Charters LLC · New Freedom, PABuilt 1977 · S/N 31-7752186 N102TMJunior Fernando Sporleder · Sarasota, FLBuilt 1976 · S/N 31-7712015 N102WHStuddiford James A · Lithia, FLS/N 31-7952066 N102WMStar Air Service LLC · Jacksonville, FLBuilt 1981 · S/N 31-8152112 N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202 N103GLNaylor Aviation LLC · Columbia, MOBuilt 1978 · S/N 31-7912023 N104MQL C Whitford Co Inc · Wellsville, NYBuilt 1979 · S/N 31-7952210 N106REColorado Aircraft Corp · Watkins, COS/N 31-7752056 N1071AOcean Group LLC · Plantation, FLBuilt 1979 · S/N 31-7952195 N108ACKaplan Steven M · Key Largo, FLBuilt 1983 · S/N 31-8312014 N108BHEmt Bahamas Holdings LLC · Greer, SCS/N 31-214 N108JLStar Marianas Aviation School Inc · Saipan, MPBuilt 1983 · S/N 31-8352028 N109FCUsda Forest Service Fepp · Tallahassee, FLBuilt 1980 · S/N 31-8012073 N10QBAsc Aviation LLC · Brandon, MSBuilt 1978 · S/N 31-7812065 N10YCToyz Aviation LLC · Worthington, KYBuilt 1979 · S/N 31-8012002 N111CFGsm Tax & Insurance Inc · Naples, FLBuilt 1976 · S/N 31-7652105 N111GAGeorges Aviation Services Inc · Honolulu, HIBuilt 1981 · S/N 31-8152050 N111UCRcht LLC · Mason, OHBuilt 1979 · S/N 31-7952190 N114NCFair Air Inc · Bloomfield Hills, MIS/N 31-8252009 N114PRC W 3 LLC · San Juan, PRBuilt 1981 · S/N 31-8152088 N114SACustom Air International LLC · Homestead, FLBuilt 1980 · S/N 31-8052053 N1157SDig2fly LLC · Sandpoint, IDBuilt 1978 · S/N 317812093 N117JPSanborn Map Company Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612086 N1187KLove Simplicity · Princeville, HIBuilt 1980 · S/N 318052175 N118MCAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952161 N11SBGrant Zachary J · Indianapolis, INBuilt 1976 · S/N 31-7612062 N120JDLamb Aviation LLC · Perris, CABuilt 1981 · S/N 31-8152179 N120LPGramer Air IV LLC · Northville, MIBuilt 1977 · S/N 31-7812010 N120MLMrl Aviation LLC · Wilmington, DEBuilt 1977 · S/N 31-7752091 N122AWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1976 · S/N 31-7652135 N123PTScheller Erik G Trustee · Gig Harbor, WAS/N 31-8112020 N124AGPegasus Enterprises LLC · Granbury, TXBuilt 1978 · S/N 31-7852103 N124WABraswell Jerrold W · Dillingham, AKS/N 31-7405242 N126DRForbis Michael · Calera, OKBuilt 1974 · S/N 31-7405173 N128MGHastings Gladstone E · Miramar, FLS/N 31-7712074 N130BVTheophanis Charters LLC · Stuart, FLS/N 31-7952216 N131PJCrosswinds Flight Center Inc · Drums, PAS/N 31-7912030 N133CTValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-7912118 N135PBD&R Holdings LLC · Kailua, HIS/N 31-7952035 N135TWValiair Lc Trustee · Casper, WYS/N 31-7852001 N137JHFlatspin LLC · Belle Chasse, LABuilt 1981 · S/N 31-8252025 N138RA & K Aviation LLC · Wenatchee, WABuilt 1972 · S/N 317300935 N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009 N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411 N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046 N140RDAlpha Whiskey 3 LLC · Brandon, MSBuilt 1975 · S/N 31-7552051

Back to AD 82-16-05 R1