Skip to content

Registered aircraft · 479

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:2005-12-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:2005-12-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:2005-12-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:2005-12-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:2005-12-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:2005-12-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.

N23GLAtlantic Assets Holding LLC · Dover, DEBuilt 1980 · S/N 414A0509 N23RHCajun Crimson Air LLC · Hoover, ALS/N 414A0258 N245JKSpruce Hill Leasing LLC · Hadley, MAS/N 414A0613 N247GSHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0637 N24SLSkye Tess Airlines LLC · Holmdel, NJBuilt 1980 · S/N 414A0610 N254TM56h LLC · St Simons Island, GABuilt 1979 · S/N 414A0254 N256CAHyannis Air Service Inc · Hyannis, MAS/N 402C0606 N258PBHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0336 N2610GBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 402C0064 N2611XHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0072 N2614LCharter Flights Caribbean Inc · San Juan, PRBuilt 1979 · S/N 402C0092 N26156Hyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0112 N2615GHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0101 N2615QVenture Air Solutions Inc · Opa Locka, FLBuilt 1980 · S/N 402C-0321 N2617NFlightcentrx LLC · Peachtree City, GAS/N 414A0273 N2618LFl & J Air Corp · West Orange, NJBuilt 1979 · S/N 414A0284 N2618VPlatz James · Auburn, MES/N 414A0285 N2619GDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 414A0290 N2619LAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1979 · S/N 414A0291 N2619Z4j Air LLC · Cartersville, GABuilt 1979 · S/N 414A0293 N261ALCkm Aircraft Holdings I LLC · Mandan, NDBuilt 1978 · S/N 414A0207 N2649ZHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0333 N26514Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0344 N2651SHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0342 N2664FWisconsin Aviation Inc · Watertown, WIBuilt 1980 · S/N 414A0534 N2664LAce Airways LLC · Quincy, WABuilt 1980 · S/N 414A0535 N2673BM & N Of Alabama LLC · Magnolia Springs, ALBuilt 1980 · S/N 414A0630 N2676YHands Holdings · Newark, DEBuilt 1981 · S/N 414A0631 N267CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0030 N2688DB2 Air LLC · Pierre, SDBuilt 1979 · S/N 414A0332 N2688MAlcyone Trust Corp Trustee · Wichita, KSBuilt 1979 · S/N 414A0334 N2688XDw Hamm Consulting LLC · Malibu, CABuilt 1979 · S/N 414A0336 N2689DRegistration Pending · Greenwood, MSRegistration pendingS/N 414A0401 N2689GShandog Air LLC · Ashland, KYBuilt 1979 · S/N 414A0402 N2689TGuillon Inc · Chico, CAS/N 414A0403 N2690TN633at LLC · Punta Gorda, FLS/N 414A0408 N2691YLa Paz Holdings LLC · Wetumpka, ALBuilt 1979 · S/N 414A0414 N2692LInnovative Aviators LLC · Norman, OKBuilt 1979 · S/N 414A0417 N2693BDiaz Charles · Ogden, UTBuilt 1979 · S/N 414A0422 N2702LE D Santos & Associates LLC · Wilmington, DEBuilt 1980 · S/N 414A0608 N270RCEagle 1-N270rc LLC · San Juan, PRBuilt 1980 · S/N 402C0269 N2712FDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 402C0121 N2715TDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 402C0214 N2718YRichland Aviation Inc · Sidney, MTBuilt 1979 · S/N 402C0232 N2727LAircraft Trustee Services Inc Trustee · Dover, DES/N 414A0602 N2729LVip Wellness LLC · Victoria, TXBuilt 1979 · S/N 414A0431 N2730MSua LLC · Artesia, NMBuilt 1980 · S/N 414A0437 N2732SBryan Aviation Co LLC · Oelwein, IAS/N 414A0448 N2732TJellor Realty Inc · Los Angeles, CABuilt 1979 · S/N 414A0449 N2734BStella Air Inc · Wyoming, PABuilt 1979 · S/N 414A0454

Back to AD 2005-12-13