Skip to content

Registered aircraft · 40,395

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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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.

N20058Ballou Skies Aviation Inc · Bucyrus, OHBuilt 1972 · S/N 17260970 N2005PCiacchi Piercarlo · Cocoa, FLS/N 23-574 N20060Bakken George S · Terre Haute, INBuilt 1972 · S/N 17260972 N200617b Flying Club Inc · Sandpoint, IDBuilt 1972 · S/N 17260973 N20063Beery Milo A DBA · Clarinda, IABuilt 1972 · S/N 17260975 N20065Southern Aero LLC · Homestead, FLBuilt 1972 · S/N 17260977 N20068Spartanburg Area Flight Education LLC · Spartanburg, SCBuilt 1972 · S/N 17260980 N20069Montel Richard D · Candler, NCBuilt 1972 · S/N 17260981 N20070Skywarrior Flight Training LLC · Pensacola, FLS/N 17260982 N20071Limaoscar LLC · Boca Raton, FLBuilt 1972 · S/N 17260983 N20072Ace Aviation 20072 LLC · Pembroke Pines, FLBuilt 1972 · S/N 17260984 N20073Gulf Coast Aviators LLC · Venice, FLBuilt 1972 · S/N 17260985 N20074Kyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1972 · S/N 17260986 N20079Celestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1972 · S/N 17260990 N2007EWallbirds LLC · San Diego, CABuilt 1978 · S/N ME-60 N2007KExecutive Flight Institute LLC · Murrieta, CABuilt 1978 · S/N ME-55 N2007P2007 Papa LLC · Fayetteville, GABuilt 1956 · S/N 23-579 N20085Fleming Ian · Peoria, AZBuilt 1977 · S/N 17702626 N20089Eagle Air Inc · Schoolcraft, MIBuilt 1972 · S/N 17260999 N2008ESchrott Bradley S · Federal Way, WABuilt 1978 · S/N ME-73 N2008TDean John W · Greentown, INBuilt 1978 · S/N M-2061 N20091Henderson Norman L · Bowling Green, MOBuilt 1972 · S/N 17261001 N20093Patterson Kyle · Tega Cay, SCBuilt 1972 · S/N 17261003 N20094Valiair Lc Trustee · Casper, WYS/N 17702627 N20095Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261005 N20097Morrison Robert J · Newport, MIBuilt 1972 · S/N 17261006 N2009DSundowner 2009d LLC · La Place, LABuilt 1978 · S/N M-2053 N2009EAce Of Spades Aviation LLC · Las Vegas, NVS/N ME-61 N2009XGriffith Aviation Inc · Griffith, INBuilt 1978 · S/N ME-66 N2009YFancy Pants Aviation LLC · Fort Worth, TXBuilt 1978 · S/N ME-74 N200ADNouvel Avion LLC · Miami Gardens, FLBuilt 1976 · S/N 28-7690230 N200BBKimbrough Charles E · Pine Mountain, GABuilt 2000 · S/N 80705 N200BDEason Charles E · Locust Grove, GABuilt 1972 · S/N AA5-0159 N200CWSkylake Adventures LLC · Geneva, OHBuilt 1994 · S/N 19017C N200DMLoudon Philip G · Manley Hot Springs, AKS/N 73 N200EMHaines Erin · The Dalles, ORBuilt 2005 · S/N 90199 N200FAYanagida Kazuaki · Norco, CAS/N FA20049 N200FWNextwerk Inc · Carlsbad, CABuilt 1975 · S/N AA5B-0194 N200GLLudeke Gary Lee · Creswell, ORBuilt 2001 · S/N 22580 N200HUVanderhoof Chad T · Elk, WABuilt 1992 · S/N 1203 N200JHHampton Maurice R · Fayetteville, ARBuilt 2000 · S/N 25052 N200KDQuantum Aero Services LLC · Wilmington, DEBuilt 1958 · S/N TD-176 N200KMFabrega Teodoro A · Doral, FLBuilt 2003 · S/N 14109C N200KRDusek Ryan · Cypress, TXBuilt 1976 · S/N 28R-7635176 N200MBPurple Plane LLC · Granbury, TXBuilt 1972 · S/N 405-72 N200MDArvelu LLC · Utica, NYBuilt 1973 · S/N 28-7305431 N200PFPrimary Flight Control LLC · Fleming Island, FLBuilt 1984 · S/N 17276085 N200PWGarris Steven L · Oceanside, CABuilt 1974 · S/N 28-7415182 N200RFRushin William J · Greenwood, INBuilt 1973 · S/N M-1457 N200USFly More LLC · Chattanooga, TNBuilt 1976 · S/N 28-7690273

Back to AD 79-10-03 R2