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.

N1954UAircraft Structural Repair Inc · Hamilton, MTBuilt 1970 · S/N 18501665 N1954VBray Aviation LLC · Calera, OKBuilt 1974 · S/N 17263803 N1954XStull David H · Sausalito, CABuilt 1965 · S/N 18256054 N1954YSasse David L · Rio Rancho, NMS/N 2691 N1955Stephens Robert Z · Missoula, MTBuilt 1955 · S/N 23004 N1955PRegistration Pending · Palmer, AKRegistration pendingBuilt 1955 · S/N 18-4182 N1955TFredericksen John · Cedarburg, WIBuilt 2021 · S/N 18283157 N1955VJd Kracl Aircraft LLC · Gretna, NEBuilt 1974 · S/N 17263804 N1955WLakeview Farm Foundation Corp · Yukon, OKBuilt 1973 · S/N MB-619 N1955YBeckworth Willis S · Gonzales, LABuilt 1964 · S/N 262 N1956Sturges George S Jr · Bakersfield, CABuilt 1956 · S/N 35337 N1956FPenzo Michael A · Stafford, VABuilt 1979 · S/N 17273046 N1956HWalker Benjamin R · Brasstown, NCBuilt 2012 · S/N 1466-2012 N1956JAdamson George R · Calhan, COBuilt 1956 · S/N 32571 N1956LMeisinger Darrell G · Claremore, OKBuilt 1976 · S/N M-1816 N1956PNormark Nancy B · Weirsdale, FLBuilt 1955 · S/N 18-4183 N1956RCorrech Jose Pedro · Cape Coral, FLBuilt 1971 · S/N 39-85 N1956SRegistered aircraftBuilt 1975 · S/N 28R-7535164 N1956VMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9934 N1956WGasaway Chad D · Middleton, IDS/N MB-620 N1957Registered aircraftBuilt 1977 · S/N 17269009 N19575Galis Iuri · Oklahoma City, OKBuilt 1976 · S/N 17702577 N1957FSteward Ashtyn L · Weatherford, TXBuilt 1979 · S/N 17273047 N1957LSmith Joseph M · Ames, IABuilt 1976 · S/N MC-423 N1957MStewart Alexander E · Medina, WABuilt 1976 · S/N 18264502 N1957RReed Gary L · Bethel, OHS/N 34578 N1957TPipers Are Still Better LLC · Carson City, NVBuilt 1971 · S/N 28R-7135177 N1957XDrummond Michael S · Burlington, NCBuilt 1965 · S/N 18256057 N1957YGuedon Aviation LLC · Natchez, MSBuilt 1964 · S/N 222 N1958Stonitsch Rudy H · Crestwood, ILBuilt 1958 · S/N D-5619 N1958BSale Reported · Champaign, ILSale reportedBuilt 1973 · S/N 17261839 N1958CCsd Enterprises Inc · Wilmington, DEExpired dealer, pending cancellationBuilt 2013 · S/N 13600 N1958LTalamini Paul J · Franklin, MABuilt 1976 · S/N M-1840 N1958PRush Brendon · Merritt Island, FLBuilt 1958 · S/N 22-6008 N1958XOrth Matthew B · Marion, KSS/N 18256058 N1958YGarner Zachary R Trustee · Anchorage, AKBuilt 1958 · S/N 50271 N1959CTisdale Anthony · Fallon, NVBuilt 1959 · S/N 51842 N1959HN1959h Aviation LLC · Hillsborough, NJBuilt 1977 · S/N 28-7790361 N1959XLyon Mark S · Layton, UTBuilt 1958 · S/N 51683 N1959YJam Aviation LLC · Wallace, MIBuilt 1964 · S/N 224 N195AJ195aj LLC · Toledo, OHBuilt 1995 · S/N 3213096 N195DLTracy Dennis E · Lafayette, COBuilt 2001 · S/N 22996 N195DWJohnson Richard G Jr · Fredericksburg, TXS/N 254 N195FAPinkston Pat · Carrollton, ILBuilt 2002 · S/N 18281095 N195FLInternational Air Services Inc Trustee · Carson City, NVBuilt 1991 · S/N E-2619 N195GMStickell Rutherford D · Frederick, MDBuilt 1994 · S/N GM-4 N195JRQualitair LLC Trustee · MichelstadtBuilt 1957 · S/N TD-15 N195MASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881029 N195MRVargas Emmanuel N · Murrieta, CABuilt 2023 · S/N 60098 N195NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11095

Back to AD 2007-04-19 R1