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.

N2234RJones Lennis William III · Rule, TXBuilt 1968 · S/N T210-0384 N2235BConner W Larry · Los Lunas, NMBuilt 1978 · S/N 28-7916120 N2235CAnderson Nick A · Cynthiana, KYBuilt 1978 · S/N 28-7911024 N2235ELivingston Eric L DBA · Winchester, INBuilt 1978 · S/N 17271198 N2235LCarter Dale · Riga, MIBuilt 1976 · S/N M-1905 N2235SN2235s LLC · Overland Park, KSBuilt 1976 · S/N 21061180 N2235VE & R Aviation Services Inc · Long Beach, CABuilt 2007 · S/N 172S10478 N2235WSamuels Walter E · Wilmington, NCBuilt 1969 · S/N 30-1844 N2236CAlexander James E Jr · Fort Worth, TXBuilt 1978 · S/N 28-7911025 N2236GParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916215 N2236PCitation X Parts LLC · Liberty, NCBuilt 1956 · S/N 23-845 N2236RSouthern Skies Aviation Inc · Cedar City, UTS/N T210-0386 N2236TParks Walter G · Chugiak, AKBuilt 1968 · S/N 185-1390 N2236UPrater Jon A · Palm Coast, FLBuilt 1967 · S/N 475 N2236WMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-7916337 N22373Roche Timothy P · Falls Church, VABuilt 2007 · S/N 18281928 N2237GSmith Caleb · Beggs, OKBuilt 1958 · S/N 51537 N2237KCarolina Air LLC · New London, NCBuilt 1978 · S/N 28-7916232 N2237LDeatherage Christina M · Goshen, OHBuilt 1976 · S/N M1885 N2237QJenkins John E Jr · Long Valley, NJBuilt 1979 · S/N 28-7911107 N2237TSchmelzle Michael O · Shrewsbury, MOBuilt 1979 · S/N 28-7916302 N2238CGorham Wendy J · Grand Rapids, MNBuilt 1953 · S/N 30538 N2238GRupp Aviation LLC · O Fallon, MOBuilt 1979 · S/N 28-7990418 N2238HRhodes Mike A · Independence, ORBuilt 1953 · S/N 25644 N2238LDeris Jeffrey J · Madison, MSBuilt 1976 · S/N MC-459 N2238UHewitt Robert E · Bybee, TNBuilt 1968 · S/N 479 N2238YFerrara Edmond · La Puente, CABuilt 1967 · S/N 17700038 N22395Morrison Donald D · Santa Clarita, CABuilt 1974 · S/N 17264063 N22396Jordan Lennon D · Bartow, FLBuilt 1972 · S/N 21059741 N2239GPotter Cleve J · Fresno, CABuilt 1958 · S/N 51539 N2239LGoss Andrew M · Clio, MIBuilt 1976 · S/N MB-821 N2239PCumbee Danny A · Geneva, ALS/N 23-848 N2239TErwin Chris L · Carson City, NVS/N 28-7125629 N223APJuliet Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13440 N223BCuster Charles D · Destin, FLS/N 001 N223BBN223bb LLC · Great Falls, VABuilt 2000 · S/N E-3340 N223BDN223bd LLC · Fresno, CABuilt 1980 · S/N R18201454 N223BECampbell Edward A · Anchorage, AKBuilt 1977 · S/N 17268915 N223BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280950 N223CGBeckett Jesse · Lakeway, TXBuilt 1947 · S/N 12-2480 N223CKBounds Keith A · Thomson, GABuilt 2004 · S/N 172S9580 N223DBurch Construction Co Inc · Ramona, CABuilt 1993 · S/N CE1755 N223DBGood Winds Aero LLC · Roseburg, ORBuilt 2000 · S/N 010197 N223DWSeibel Keith L · Paris, TNBuilt 1963 · S/N D-7113 N223EMKqm Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282252 N223GLKushner Herbert A · Bridgewater, NJBuilt 1973 · S/N 337-73 N223HWatson James E Jr · Victor, COBuilt 1956 · S/N 35385 N223HCG206 LLC · San Juan, PRBuilt 2006 · S/N 20608269 N223HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 17281112 N223HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHBuilt 1990 · S/N 1600

Back to AD 2007-04-19 R1