Registered aircraft · 108,428

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.

N15MEnglish Dexter · Syracuse, KSBuilt 1964 · S/N CD-794 N15MCAir Heritage Inc · Beaver Falls, PABuilt 1956 · S/N BG-295 N15MHRegistered aircraftBuilt 1979 · S/N 6107338062145 N15MJRegistered aircraftBuilt 2024 · S/N 172S13005 N15MLN15ml LLC · Cresskill, NJBuilt 1977 · S/N 21061780 N15MVAir Bellers Inc · Sunnyvale, CABuilt 2017 · S/N 18282388 N15MWZeezee LLC · Phoenix, AZBuilt 1978 · S/N 21063023 N15NBMorris Russell K · Cameron Park, CABuilt 1978 · S/N AA5B0974 N15NCHerberg Hayley · Reno, NVBuilt 1966 · S/N CE-12 N15NFRegistered aircraftBuilt 1969 · S/N 17258204 N15NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 172RG0115 N15PAFlight Dynamics LLC · De Leon Springs, FLBuilt 1980 · S/N 18053148 N15PCCarr Patrick L · Fairmont, WVBuilt 1997 · S/N 1214 N15PJBreedlove Ernest Dale · Valley Mills, TXBuilt 1999 · S/N 23313 N15PKJones Helicopters LLC · Villa Rica, GABuilt 2012 · S/N 13256 N15PMDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N E-1016 N15PQUsda Aphis Ws Atoc · Cedar City, UTBuilt 2010 · S/N CC18-0043 N15PTThyssen Patrick L · Conroe, TXBuilt 2009 · S/N 40257 N15PUNorth Valley Aircraft Inc · Valley City, NDBuilt 1989 · S/N 3015 N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388 N15RAAviation Career Enrichment Inc · Atlanta, GABuilt 1970 · S/N 17259568 N15RDWood Richard W Trustee · Oroville, CABuilt 1978 · S/N E-1407 N15RHRansdell Thomas R · Boerne, TXBuilt 2010 · S/N E-3942 N15RJColston David T · Vero Beach, FLBuilt 1968 · S/N CE-199 N15RMFlying Y Farms LLC · Klamath Falls, ORBuilt 1969 · S/N 18-8814 N15RPKnob Creek Aviation LLC · Oak Ridge, LABuilt 1974 · S/N E-539 N15RRMcdonald Joseph T · Auburn, ALBuilt 1966 · S/N 332 N15RSCalvert Gregory E · Essex, MDBuilt 1973 · S/N 18261885 N15RVCrawford Larry G · California, MOS/N 298 N15RXLingo Aviation LLC · Cincinnati, OHBuilt 2004 · S/N 1164 N15SEWilliams Paul E · Kendallville, INBuilt 2005 · S/N 1386-2005 N15SVGore Joshua · Sedro Woolley, WABuilt 1977 · S/N 340A-0226 N15SWNi Oliver Xingyuan · Norfolk, VABuilt 1968 · S/N 17256875 N15SZZurcher Susan R · Hampshire, ILBuilt 2022 · S/N 18283202 N15TTray Aircraft Leasing LLC · Port Richey, FLBuilt 1964 · S/N TC-626 N15TABasham Kristina · Danville, CABuilt 2001 · S/N 6045 N15TBEast West Helicopter Inc · Batesville, INBuilt 1979 · S/N 21063331 N15TKSpence William D · Waller, TXBuilt 1988 · S/N 1 N15TPSmith Richard R · Austin, TXBuilt 2006 · S/N 1990 N15TSSchell Timothy N · Dubois, WYBuilt 1996 · S/N 23802 N15TYArneson Kenneth W · Beaverton, ORBuilt 1975 · S/N 150-76713 N15USale Reported · Van Nuys, CASale reportedBuilt 1979 · S/N ME-160 N15USFlypower Inc · Fort Lauderdale, FLBuilt 1975 · S/N 21060676 N15VMGagne Jay A · Dyersburg, TNBuilt 1976 · S/N D-9936 N15VRCarley Daniel · Center Moriches, NYBuilt 1998 · S/N 21486 N15VVLiberty Flying Club Inc Trustee · Wilmington, DEBuilt 1990 · S/N 340A1520 N15WAG Force Aerobatics LLC · Eugene, ORBuilt 1992 · S/N 5247 N15WGSwirk Rhonda L · Center Conway, NHBuilt 1968 · S/N 18259444 N15WJFleming Laurence Erik · Salinas, CABuilt 1999 · S/N 824-99 N15WMSidhu Teg Singh · Bakersfield, CAS/N 340A0523

Back to AD 2007-04-19 R1