Skip to content

Registered aircraft · 6,916

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N395MEYqa Capital Management LLC · Murfreesboro, TNBuilt 2000 · S/N T20608233 N395PMBare Bones Aircraft Inc · Fort Walton Beach, FLBuilt 1995 · S/N 4622195 N39603Bauer Jay A · Carrington, NDBuilt 1978 · S/N 32R-7887119 N39613Ferrando James P · San Pedro, CABuilt 1978 · S/N 32-7840170 N39619Harclerode David A · Colorado Springs, COBuilt 1978 · S/N 32R-7887122 N39637Crawford Ted J DBA · Elma, IAS/N 32R-7887129 N39639Anselmi Alessandro · Cleveland, SCBuilt 1978 · S/N 32R-7887130 N39650Bas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7887132 N39654Scarlet Peregrine LLC · Flagler Beach, FLBuilt 1978 · S/N 32R-7887134 N39659Ruijne Paul · Plainview, TXS/N 32R-7887136 N39660Your Mission LLC · Vinton, IABuilt 1978 · S/N 32R-7887142 N39671N39671 Aviation LLC · Wilmington, DEBuilt 1978 · S/N 32-7840175 N39673Signorino Joseph E Trustee · Bath, NCBuilt 1978 · S/N 32R-7887139 N39690Basin Ag Imaging LLC · Hermiston, ORBuilt 1978 · S/N 32R-7887145 N396LRRupiper Larry · Yankton, SDBuilt 1978 · S/N 32R-7885238 N396MCJf Aviation LLC · Minot, NDBuilt 2005 · S/N T18208396 N39706Parks David V · Plant City, FLBuilt 1978 · S/N 32R-7887151 N39707Risley Gary Trustee · Farmington, NMBuilt 1978 · S/N 32R-7887118 N39719Pena Felix A · Salem, SCBuilt 1978 · S/N 32R-7887152 N39744Mytrex Properties LLC · South Jordan, UTBuilt 1978 · S/N 32R-7887159 N3975CMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2007 · S/N 4636419 N39771Ainley Alan · Paragould, ARBuilt 1978 · S/N 32-7840177 N39773Brittain Brett · Clinton, OKBuilt 1978 · S/N 32R-7887164 N397MWMccann Shawn Edward · Newton, NJBuilt 2005 · S/N T18208397 N397PMAircraft 445 LLC · Porterville, CABuilt 1997 · S/N 4636113 N397TBLiberty Industries LLC · Washington, DCBuilt 1997 · S/N 1804 N397TCBravo & Bravo LLC · Greenville, MEBuilt 2003 · S/N T20608397 N39811Ozarks Auto Show Inc · Hollister, MOS/N 73-32-98 N39828Burns William L · Spring Lake, MIBuilt 1972 · S/N 73-31044 N39834Mrd Aero LLC · Manheim, PABuilt 1972 · S/N 73-30523 N39851Kuhns Bart D · Sedalia, MOBuilt 1972 · S/N 73-32-100 N39873Iverson Jason S · Mission, TXBuilt 1973 · S/N 73-31054 N39886Rucker Stephen J · Montevideo, MNBuilt 1973 · S/N 73-30554 N39895Catalanotto Victor · Mansfield, TXBuilt 1973 · S/N 73-32-112 N3989XEdgar Mary E · Butler, TNBuilt 1975 · S/N 32-7640007 N398PMN398pm LLC · Atlanta, GABuilt 1998 · S/N 4636145 N398TCC & H Air Direct Flight Service Inc · Wilmington, DEBuilt 1998 · S/N 3257057 N398WFOn Demand Aviation LLC · Port Orange, FLBuilt 2018 · S/N 4636734 N39909Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 73-32-113 N39921Guevara Cerrato Edras O · Downey, CAS/N 32R-7887167 N39941Devoll Jeffrey · Sacramento, CABuilt 1978 · S/N 32-7840179 N39944Simple Kindness Nfp · Naperville, ILBuilt 1978 · S/N 32R-7887171 N3998FButler Aluminum Of Desoto · Arcadia, FLBuilt 1976 · S/N 32R-7680424 N3999XK-Viation LLC · Paulding, OHBuilt 1975 · S/N 32-7640008 N39BBHammonds Willard H II · Corpus Christi, TXBuilt 2005 · S/N T18208360 N39HASmc Ltd · Somerset, WIS/N 31-497 N39JEDuxbury Piper LLC · Duxbury, MABuilt 2010 · S/N 4636479 N39THBrandell LLC · Wilmington, DEBuilt 2001 · S/N 3257225 N3BSEcho 7 Tango Aviation LLC · Pottsboro, TXBuilt 1973 · S/N 32-7340179 N3FPritt Thomas S · Lake Placid, FLBuilt 1976 · S/N 61P-0341-101

Back to AD 71-13-01 R1