Skip to content

Registered aircraft · 689

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:96-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13') 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:96-24-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13')
  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:96-24-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13')
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.

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 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, WAFirst renewal noticeBuilt 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 N300WAThunderbolt Air LLC · Granbury, TXBuilt 1968 · S/N 31-294 N302TAMidwest Flying Service LLC · Wilmington, DEBuilt 1980 · S/N 31T-8020046 N305YWRichard L Richards P A Trustee · Coral Gables, FLBuilt 1977 · S/N 31-7852016 N30DRRuble Force One LLC · Wilkinson, INBuilt 1978 · S/N 31-7912006 N30DUHtf Aviation LLC · Kalispell, MTS/N 31T-7720054 N30SAMsm30sa LLC · Jericho, NYS/N 31-7952142 N30SCRegistration Pending · Wauchula, FLRegistration pendingBuilt 1981 · S/N 31-8152098 N30TPLe Ciel Bleu LLC · Hudson, WIBuilt 1981 · S/N 31-8152062 N312AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1973 · S/N 31-7305015 N312CDMcwhorter Properties Graysville LLC · Anniston, ALBuilt 1980 · S/N 31-8052182 N314K314-K Associates LLC · Stratford, CTBuilt 1983 · S/N 31-8352025 N315AKAlsworth Glen R Sr · Port Alsworth, AKBuilt 1978 · S/N 317852083 N316AKKuspuk School District · Aniak, AKS/N 318152118 N316HABidzy To Hot Aana Corp · Dillingham, AKS/N 31-7652133 N317AKSafeco Leasing LLC · Port Alsworth, AKS/N 31-7752145 N317HABauer Aviation LLC · Saint Germain, WIBuilt 1977 · S/N 31-7812043 N317SFLasher Patrick R · Magnolia, DES/N 31-7300912

Back to AD 96-24-13