Skip to content

Registered aircraft · 755

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.

N53TAIndiana Paging Network Inc · La Porte, INBuilt 1978 · S/N 31T-7820083 N543133seaslal LLC · Lakeland, FLBuilt 1974 · S/N 31-7405439 N543JCBritshaw LLC · Lansdale, PABuilt 1977 · S/N 31-7752103 N543SBBielder Street Aviation LLC · North Charleston, SCBuilt 1979 · S/N 31-7912034 N545RKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 31T-7720064 N549JBBlue Bird Aviation LLC · Ocean City, MDBuilt 1980 · S/N 31-8052108 N54CLAir Transport Resources · Naperville, ILBuilt 1970 · S/N 31-652 N54WAWright Air Service Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652067 N554KDWestern Air International Co · Pompano Beach, FLBuilt 1979 · S/N 31-7952157 N555FRWallace Jeffrey S · Bonita Springs, FLS/N 31T-8004010 N555FSJacko Josh E · Anchorage, AKBuilt 1978 · S/N 31-7952046 N555GTRegistered aircraftBuilt 1979 · S/N 31-7952148 N555JGLeia Air LLC · Wilmington, DEBuilt 1979 · S/N 31-8012018 N555MFCloud 555 Inc · Wilmington, DEBuilt 1980 · S/N 31-8012068 N55RPneuma Aviation LLC · New Orleans, LABuilt 1976 · S/N 31T-7620055 N565BTGsg Aviation LLC · Fort Lauderdale, FLBuilt 1980 · S/N 31-8052118 N56MHB S Aviation LLC · Stuart, FLBuilt 1979 · S/N 31-7952068 N56MJBishop Ronald Daniel · Port Orange, FLBuilt 1981 · S/N 31-8152108 N56PCValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-8052005 N57539Registration Pending · Meriden, CTRegistration pendingBuilt 1976 · S/N 31P-7630002 N575EHajdukovich Robert M · Fairbanks, AKBuilt 1976 · S/N 31-7652006 N57GPFoncho Corp · San Juan, PRBuilt 1982 · S/N 31-8252043 N596LKcc Aero LLC · Guaynabo, PRBuilt 1977 · S/N 31-7712036 N59752Visionaire Enterprises LLC · Statesville, NCBuilt 1975 · S/N 31-7612010 N59764Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1975 · S/N 31-7652037 N59777Sofisa Airways Corp · Coral Gables, FLBuilt 1976 · S/N 31-7612020 N59809Lou Dell Aviation LLC · Simpsonville, SCBuilt 1976 · S/N 31-7612037 N59826Air Arctic Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652077 N59829Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652081 N59848Sanborn Map Co Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612052 N59865Mccorkle Joseph P II · Tyronza, ARBuilt 1976 · S/N 31-7612065 N59867Cooper Keith L · Tabernash, COBuilt 1976 · S/N 31-7612068 N59906Alpha Whiskey 2 LLC · Brandon, MSBuilt 1974 · S/N 31-7552027 N59936Kelly Kent R · Montgomery, ALBuilt 1975 · S/N 31-7512019 N59982Duck L'Ranch LLC DBA · Fort Lauderdale, FLBuilt 1975 · S/N 31-7552071 N59987Wings As Eagles Mission Air Serv Inc · Oshkosh, WIBuilt 1975 · S/N 31-7552081 N599AHAvtran LLC · Clayton, MOBuilt 1984 · S/N 31-8452019 N59EHSale Reported · Dawsonville, GASale reported, pending cancellationBuilt 1978 · S/N 31T7820014 N59FCLamb Farms Inc · Oakfield, NYBuilt 1979 · S/N 31-7952117 N59GYChieftain N59gy LLC · Saint Augustine, FLBuilt 1977 · S/N 31-7852017 N59JCPegasus Air Charter LLC · Hartford, CTBuilt 1979 · S/N 31-7952181 N5DValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 31T-7820080 N601AJShamrock Aviation LLC · Madison, MSBuilt 1984 · S/N 31T-1104013 N606DWElkhorn Valley Trucks II LLC · Fremont, NEBuilt 1981 · S/N 31T-8120038 N606JSStar Marianas Aviation School Inc · Tinian, MPS/N 31-7952145 N60AY2701 Ne 27 Court LLC · Hollywood, FLBuilt 1981 · S/N 31-8152051 N60CGSaj Aviation LLC · Reading, PABuilt 1980 · S/N 318052206 N60JWTumbleweed Leasing LLC · Tacoma, WABuilt 1980 · S/N 31T-8004031 N60TAAero Elite LLC · Springfield, MOS/N 31-7552094 N6107AR & R Aviation Support LLC · Atlanta, GABuilt 1978 · S/N 31T-7820087

Back to AD 82-27-13 R2