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.

N2385YSpeedboat Photo Helicopter LLC · Rehoboth Beach, DES/N 0538 N2385ZStacy Rick A · Arlington, OHBuilt 2016 · S/N 70554 N2386CSuiter Thomas D · Earl Park, INBuilt 1978 · S/N R18200173 N2386ENiblack Ward Scott · Tecumseh, MIBuilt 1978 · S/N 17271261 N2386MHoeffler James P · Fort Collins, COBuilt 1946 · S/N 12-1628 N2386RLand Air & Sea LLC · Concord, NCBuilt 1970 · S/N 28-5602 N2386THub City Aviation Academy LLC · Lubbock, TXBuilt 1971 · S/N 28-7225065 N2386VEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1999 · S/N 17280702 N2386ZHoffman Kurt T · Savannah, GABuilt 1962 · S/N M-109 N2387BMacken Inc Corp · Saint Paul, MNBuilt 1948 · S/N 3687 N2387CEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 30687 N2387FMitten Daniel L · Hatfield, PABuilt 1965 · S/N 21058587 N2387GPitsch Air Service · Grand Rapids, MIBuilt 1959 · S/N 51687 N2387RLeroux Fernand Dean · Lagrange, GABuilt 1964 · S/N 18255487 N2387SWittkop Joseph D · Dillingham, AKBuilt 1979 · S/N 18-7909142 N2387UChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280721 N2388CRicottilli Stanley L · Mill Creek, WVBuilt 1953 · S/N 30688 N2388GFlat Top Sheep Co · Carey, IDBuilt 1958 · S/N 51688 N2388XSeiler Richard · Bozeman, MTBuilt 1965 · S/N 18256288 N2388YMay James E · Nashville, GABuilt 1967 · S/N 17700188 N2388ZKoehler Brian L · Washington, IAS/N M-94 N2389RB2fh Ltd · Allentown, NJBuilt 1964 · S/N 18255489 N2389SPhillips Aviation Enterprises Inc · Petoskey, MIBuilt 1979 · S/N R18201335 N2389VMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280729 N2389WCherney Cody L · Belleville, KSBuilt 1966 · S/N MB-24 N238ARN238ar LLC · Hickory, NCBuilt 2002 · S/N 0346 N238ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496037 N238CDHerega Mark Allen Sr · Brick, NJBuilt 2002 · S/N 0359 N238CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283016 N238DSilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608238 N238DMCopeland Gary L · Williamsburg, MIBuilt 1972 · S/N 19-72 N238DSRegistration Pending · Plainwell, MIRegistration pendingBuilt 1987 · S/N CE-1146 N238ESSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 52854 N238FYSpace Coast Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841175 N238GMac-V Aviation Inc · Central Point, ORBuilt 2007 · S/N 196C N238LSMckissock Mark D · Cambridge Springs, PABuilt 2011 · S/N 91019 N238MAFogg Phillip G · Aurora, ORBuilt 1998 · S/N 5238 N238MCBrotherton Douglas E Trustee · Dubuque, IABuilt 1993 · S/N 3213047 N238MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881816 N238MJRivard Matthew G · Kansas City, MOBuilt 2025 · S/N 42596 N238NDPlane Nonsense · Middletown, DEBuilt 2000 · S/N 2842101 N238RTTorres Ramon A · Mulberry, FLBuilt 1972 · S/N 506 N238RVRegistered aircraftS/N 23880 N238SAzure II Flight Time LLC · Leesburg, FLBuilt 1965 · S/N CD-920 N238SAJmm Capital LLC · Fort Worth, TXBuilt 2000 · S/N E-3321 N238SPEdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8223 N238SSAppling Aviation LLC · Baxley, GABuilt 2020 · S/N JA 559-7-19 N238TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020238 N238THLewis University · Romeoville, ILBuilt 2018 · S/N 172S12140 N238TWDunlap Allan D · Spokane, WABuilt 1981 · S/N 17275287

Back to AD 2007-04-19 R1