Registered aircraft · 108,433

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N2376RRegistered aircraftBuilt 1999 · S/N 18280431 N2376TStranberg Ray L · Bakersfield, CAS/N 28-7225057 N2376VPeyrot Eric M · Summerland Key, FLBuilt 1998 · S/N 18280432 N2376XMueller Howard W · Winston Salem, NCBuilt 1999 · S/N 18280433 N2377Young Robert L · Oakwood, ILBuilt 1970 · S/N 16408488 N2377CCooper Capital Specialty Salvage LLC · Old Saybrook, CTBuilt 2024 · S/N E-4156 N2377EBeck Roger M Trustee · Goode, VABuilt 1978 · S/N 17271256 N2377FBuoni Frank · Bakersfield, CABuilt 1965 · S/N 21058577 N2377GLutz Matthew S · Lewistown, MTBuilt 1958 · S/N 51677 N2377LBarnes Matthew · Cost, TXS/N M-217 N2377PLammers William Scott · Deer Park, ILBuilt 1998 · S/N 18280434 N2377UCardinal Flight Systems LLC · Cary, NCBuilt 1979 · S/N 28-8016021 N2377XBieker Tor M · Hood River, ORBuilt 1965 · S/N 18256277 N2377YTerral William C · Farmerville, LABuilt 1998 · S/N 18280436 N2377ZMatthews Grover C · Hardinsburg, KYBuilt 1979 · S/N 27-7954116 N2378Suridutch Inc · Englewood, FLBuilt 1992 · S/N 2066 N23782Zylstra Cycle Co Inc · Ames, IAFirst renewal noticeBuilt 1999 · S/N 18280448 N2378CHovda H O · Progreso, TXBuilt 1953 · S/N 30678 N2378GStramel Matthew J · Elko, NVBuilt 1958 · S/N 51678 N2378TKeiffer Taylor H · Atlanta, GABuilt 1971 · S/N 28-7225059 N2378UInternational Flight Academy LLC · Ft Worth, TXBuilt 1979 · S/N 28-8016022 N2378ZMugleston Tim H · Waldport, ORBuilt 1962 · S/N M-102 N23798Jet Air Inc · Iowa City, IABuilt 1998 · S/N 17280603 N2379CWest Country Aviation Inc Trustee · Wilmington, DEBuilt 1978 · S/N R18200170 N2379KEast Bay Inc · Stanton, MNBuilt 1979 · S/N 18-8009054 N2379RLanzetta Kenneth · Oakland Park, FLBuilt 1979 · S/N 18266988 N2379XK Fortner LLC · San Marcos, TXS/N 18256279 N2379YThelwell Llansley · Frisco, TXBuilt 1967 · S/N 17700179 N237AJSuo Anttila Ahti · Albuquerque, NMBuilt 2000 · S/N 18280794 N237BMarcum William N · Corpus Christi, TXBuilt 2003 · S/N 60070 N237CADepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608239 N237CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282348 N237CSHorizon Flyers LLC · Kingsford, MIBuilt 1968 · S/N 28-24230 N237CTSkymax LLC · Stanford, KYBuilt 1968 · S/N 18258819 N237DWTheis Industrial Leasing Inc · Spivey, KSS/N 35506 N237FBGomez Preston Andreas · Bismarck, NDBuilt 2007 · S/N 18281916 N237FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2842015 N237HHatfield R Andrew · Grand Junction, COBuilt 1996 · S/N 022 N237HYZeus Flight LLC · Ketchum, IDBuilt 2003 · S/N 2237 N237KBHenke Aircraft Holdings LLC · Dayton, TXBuilt 1978 · S/N 78-31144 N237LSSouth Florida Ultralights Inc · Mulberry, FLBuilt 2020 · S/N 21242 N237MArdizzone Mark R · Mckinney, TXBuilt 1965 · S/N 293 N237MEWestbank Fishing LLC · Kiln, MSBuilt 2000 · S/N 18280756 N237MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881815 N237MLN237ml LLC · Glennallen, AKS/N 18-6787 N237RDGracely Richard H · Durham, NCBuilt 2023 · S/N 20494 N237SColey Douglas E · Mchenry, ILBuilt 1965 · S/N D-7841 N237SKAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13469 N237THWingsleasing LLC · Wichita, KSBuilt 2018 · S/N 172S12136 N2380Atlantic Rotors LLC · Saint Inigoes, MDBuilt 1992 · S/N 2070

Back to AD 2007-04-19 R1