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.

N2471RFykerud Eric J Sr · Bend, ORBuilt 1964 · S/N 18255571 N2471TLarue Mark C · Leander, TXS/N NAV-4-2471 N2471USchroeder Nyla R · Minneapolis, MNBuilt 1979 · S/N 28-8090049 N24726Hoover Darin J · San Antonio, TXBuilt 2014 · S/N 74097 N2472FParr Crawford B · Anchorage, AKBuilt 1966 · S/N 18051674 N2472QSalzman Denise M · Cameron Park, CABuilt 1966 · S/N 18257672 N2472RVac New Inc · China Village, MENon-citizen corporation, flight hours not reportedBuilt 1964 · S/N 18255572 N2472UMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10074 N2472XPhillips Robert Frank · Tabernacle, NJBuilt 1965 · S/N 18256372 N2472YAndrews Kevin M · Riverside, CABuilt 1970 · S/N E-254 N2473CLewis Eddy L · Cortez, COBuilt 1954 · S/N 30773 N2473GFly For Fun Aircraft LLC · Baltimore, MDBuilt 2001 · S/N 17281019 N2473PAnderson Tony V · Pendleton, ORBuilt 1955 · S/N 22-2848 N2473RRonald O Holcomb LLC · Lapeer, MIBuilt 1964 · S/N 18255573 N2473WCahill Chad · Edmond, OKBuilt 1985 · S/N 28-8590073 N2473YFunderburg Erskine R · Pell City, ALBuilt 1985 · S/N 28-8590074 N2473ZGulf Coast Aviation LLC · New Orleans, LABuilt 2005 · S/N 172S10082 N24748Delta State University · Cleveland, MSBuilt 2001 · S/N 17281051 N2474CArchitectural Industrial Rentals LLC · Wilmington, DEBuilt 2001 · S/N 18280978 N2474PSeidel William G Jr · Poway, CABuilt 1955 · S/N 22-2849 N2474QBurnet Aviation Group LLC · Bertram, TXBuilt 1966 · S/N 18257674 N2474TNavionic Vagabond LLC · Leesburg, VABuilt 1962 · S/N NAV42474 N2474XKramer William L · Wellington, FLBuilt 1965 · S/N 18256374 N2474YLogan Air Services LLC · Logan, UTBuilt 2005 · S/N 172S10083 N24756Wings Over Texas Holdings LLC · Denton, TXBuilt 2005 · S/N 172S10086 N2475CHansen Curtis · Merrimack, NHBuilt 1954 · S/N 30775 N2475LDeralex Airways LLC · Miami, FLBuilt 2001 · S/N 17280990 N2475PErickson Scott L · Omaha, NES/N 22-2796 N2475QStumpf Walter · Tulsa, OKBuilt 1966 · S/N 18257675 N2475XJohnston Bruce W · Puyallup, WABuilt 1965 · S/N 18256375 N2476CBrown Jack P · Anchorage, AKBuilt 1954 · S/N 30776 N2476ESkyspot Advertising LLC · Lakeland, FLBuilt 2001 · S/N 172S8784 N2476JCrosshares Aircraft Holdings LLC · Plymouth, INBuilt 2001 · S/N 172S8785 N2476MPremier Flight Center LLC · Hartford, CTBuilt 1977 · S/N 28-7816286 N2476RBascom Richard J Trustee · Elkhart, IABuilt 1964 · S/N 18255576 N2476YAmerican Aviation Inc · Brooksville, FLBuilt 2005 · S/N 172S10087 N2477FChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10574 N2477GRamsey Stephen C · Aspen, COBuilt 1958 · S/N 51777 N2477RJohnson Michael W · Kensington, OHBuilt 1964 · S/N 18255577 N2477SAverett University · Danville, VABuilt 2012 · S/N 2843700 N2477T7 Shooter Ranch LLC · Aledo, TXBuilt 1971 · S/N 28-7205055 N24780San Diego Flight Training International Inc · San Diego, CABuilt 2001 · S/N 17281028 N24783Elite Approach LLC · Chesterfield, MOBuilt 2001 · S/N 17281029 N24787W Tech Consulting Inc · Wilmington, DEBuilt 2001 · S/N 172S8804 N2478FSchad Paul E · Gainesville, TXBuilt 1966 · S/N 18051680 N2478GGilliland Sandra K · Julian, NCBuilt 1959 · S/N 51778 N2478PDickinson Scott S · Coeur D Alene, IDBuilt 1979 · S/N 18-8009056 N2478QAbraham Curtis L · Byron, WYBuilt 1966 · S/N 18257678 N2478RWeber Alan M · Manteca, CABuilt 1964 · S/N 18255578 N2478T5b Aviation LLC · Duncan, OKBuilt 1971 · S/N 28-7205059

Back to AD 2007-04-19 R1