Skip to content

Registered aircraft · 756

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-27-13-R2') 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-27-13-R2') 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-27-13-R2')
    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-27-13-R2')
  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-27-13-R2')
  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-27-13-R2')
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 N100YGAnderton Doyle M · Royse City, TXS/N 31P-7530010 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 N105MAMorrison Andrew · Haverford, PABuilt 1980 · S/N 31T-8104015 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 N108UCHot Springs Flyers Inc · Covington, LABuilt 1979 · S/N 31T-8020018 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 N111JFJoyce Aviation Inc · Winston Salem, NCBuilt 1981 · S/N 31T8120012 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 N115BMAshland Water Group · Ashland, OHBuilt 1982 · S/N 31T-8120053 N115PCDodson International Parts Inc · Pelkie, MIBuilt 1977 · S/N 31T-7820001 N117JPSanborn Map Company Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612086 N1183GC A R Lease Corp · Brentwood, TNBuilt 1979 · S/N 31T-7920086 N1187KLove Simplicity · Princeville, HIBuilt 1980 · S/N 318052175 N118HBTd Air LLC · Cromwell, CTBuilt 1980 · S/N 31T-8004052 N118MCAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952161 N118WCHalair Inc · Diablo, CABuilt 1979 · S/N 31T-8020020 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 N123JHFti Group LLC · Norman, OKS/N 31P-7630010 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 N1250CBravan Aviation · Fort Lauderdale, FLS/N 31P-7530011 N126DRForbis Michael · Calera, OKBuilt 1974 · S/N 31-7405173 N128MGHastings Gladstone E · Miramar, FLS/N 31-7712074

Back to AD 82-27-13 R2