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.

N27272Alpha United Air LLC · Wilmington, DEBuilt 1977 · S/N 31-7712063 N27282Sanborn Map Company Inc · Colorado Springs, COBuilt 1977 · S/N 31-7712071 N27299C M B Aviation LLC · Farmington Hills, MIBuilt 1977 · S/N 31-7752128 N27405N27405 Holding LLC · Palm City, FLBuilt 1977 · S/N 31-7752164 N27418Sun Aircraft Management LLC · Ormond Beach, FLS/N 31-7752169 N27423Kadrmas Arnold E · Lewiston, IDBuilt 1977 · S/N 31-7752173 N27447Laingkids LLC · Lewes, DEBuilt 1977 · S/N 31-7812022 N27449Airchoice LLC · Manchester, IABuilt 1977 · S/N 31-7812025 N27450Flying Oyster Investments II LLC · Apollo Beach, FLBuilt 1977 · S/N 31-7812027 N27471Grant Aviation Inc · Anchorage, AKBuilt 1977 · S/N 31-7852018 N27478Hughes Ronnie D · Cedar Park, TXBuilt 1977 · S/N 31-7852026 N27481Sanborn Map Company Inc · Colorado Springs, COBuilt 1978 · S/N 31-7812009 N27527N27527 LLC · Florence, SCBuilt 1977 · S/N 31-7852044 N27528Seacrest Seven LLC · Savannah, GABuilt 1977 · S/N 31-7852045 N27562Montcalm-Mcdonald LLC · Mansfield, LABuilt 1978 · S/N 31-7812050 N275CFFlyers Of The Americas Pr LLC · Guaynabo, PRS/N 318252017 N275CTInfinity Real Estate LLC · Guaynabo, PRBuilt 1979 · S/N 318052019 N27647Aviation Department Inc · Avon Park, FLBuilt 1978 · S/N 31-7812084 N2765VWiebe Frank · Wellington, TXBuilt 1978 · S/N 31-7812048 N27663Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1978 · S/N 31-7852094 N27666Lee Stephan J · Sacramento, CABuilt 1978 · S/N 31-7852097 N27674Georges Aviation Services Inc · Honolulu, HIBuilt 1978 · S/N 31-7852100 N27682D And R Hobbs Properties LLC · Rogers, ARBuilt 1978 · S/N 31-7852105 N27693Sanborn Map Co Inc · Colorado Springs, COBuilt 1978 · S/N 31-7812091 N27699Curnutt Daniel E · Tanner, ALBuilt 1978 · S/N 31-7812094 N27701Secure Aviation Inc · Tequesta, FLBuilt 1978 · S/N 31-7812096 N27712Juliet Lima Marketing Inc · West Palm Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 31-7812102 N27755Air Arctic Inc · Fairbanks, AKBuilt 1978 · S/N 31-7852148 N27800International Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852156 N27835Aerowerks LLC · Louisville, KYBuilt 1978 · S/N 31-7912016 N27888Tep LLC · Ormond Beach, FLBuilt 1978 · S/N 31-7952025 N27917Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1978 · S/N 31-7952007 N27989Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-7952077 N27990Aztec Worldwide Airlines Inc · Wilmington, DEBuilt 1979 · S/N 31-7952079 N279CTShelton Paul K · Flushing, NYBuilt 1973 · S/N 31P-7300172 N27BFJab Air LLC · Ponte Vedra Beach, FLBuilt 1981 · S/N 31T-8104038 N283GTKinz Air LLC · Winter Springs, FLBuilt 1979 · S/N 31-7952139 N284HBAviatiek LLC · Hudsonville, MIBuilt 1979 · S/N 31-7912099 N284SBWestwind Inc · Liberal, KSS/N 31T-7820074 N285MEN285me Holding LLC · Palm City, FLS/N 31-7405410 N28BGKapowsin Air Sports Ltd · Shelton, WABuilt 1976 · S/N 31T-7720005 N28DFGlobal Avionics LLC · Downey, CAS/N 31-7812121 N28DVHood Geoffrey A · Gladstone, MOS/N 31-7912063 N28KEGrant Aviation Inc · Anchorage, AKS/N 31-8152049 N294ZPCumulus Aviation Inc Trustee · Wilmington, DEBuilt 1980 · S/N 31T-8020063 N296CHTgl Partners LLC · Plant City, FLBuilt 1978 · S/N 31-7812062 N297JGInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 317952043 N2PNFugro USA Land Inc · Rapid City, SDBuilt 1977 · S/N 31-7752141 N2XRInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 318152014 N300SRLevenson Louis · Atlanta, GABuilt 1981 · S/N 31T-8104022

Back to AD 82-27-13 R2