Skip to content

Registered aircraft · 806

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:93-24-02-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:93-24-02-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:93-24-02-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:93-24-02-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:93-24-02-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:93-24-02-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.

N250MDInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31-742 N253DSIpmad Vpmc Aerial Mosquito Control · New Iberia, LABuilt 1980 · S/N 31-8052142 N2556RRed Willow Rescue Inc · Cooperstown, NDBuilt 1979 · S/N 31T-8004003 N257SHDodson International Parts Inc · Rantoul, KSS/N 31-8052121 N2598NRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1984 · S/N 31P-8414050 N262ASAerodata LLC · Ann Arbor, MIBuilt 1977 · S/N 31-7712102 N262LRValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 31T8104002 N26GPGpi Geospatial Inc · Orlando, FLBuilt 1977 · S/N 31-7812001 N271ABHoney Badger LLC · Tulsa, OKBuilt 1979 · S/N 31T-7904024 N271ASSkattum LLC · Sioux Falls, SDBuilt 1976 · S/N 31-7612073 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 N282PCW O Powers Management Inc · Florence, SCBuilt 1981 · S/N 31T-8166006 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

Back to AD 93-24-02 R1