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.

N1794TGear Up Aircraft Rental LLC · Warner Robins, GABuilt 1971 · S/N 28-7125133 N1794WSkyhawk Flying Club Inc · Omaha, NEBuilt 1972 · S/N E-380 N1794XGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 21060814 N1795CSchellhaas Bennett · Galloway, OHBuilt 1953 · S/N 30495 N1795ERb Aviation LLC · Tyler, TXBuilt 1979 · S/N 310R1577 N1795GProps2jets LLC · Bolingbrook, ILBuilt 1962 · S/N D-6977 N1795RBroussard Kenneth John · Lafayette, LABuilt 1974 · S/N 18502511 N1796GHorowitch Alan · San Diego, CABuilt 1975 · S/N 310R0048 N1796PMcmahan C Merrill · Wausau, WIBuilt 1954 · S/N 22-2569 N1796TReavis John F · Harmony, NCS/N 28-7125135 N17979Alford Flying LLC · Wichita, KSBuilt 1977 · S/N TH-832 N1797CKelley Larry D · Portland, ORBuilt 1953 · S/N 30497 N1797GTabor Tobey R · Ventura, CABuilt 1962 · S/N D-6975 N1797MCp & R Transport LLC · Grace, IDBuilt 1975 · S/N 18264450 N1797PSherman John · Northport, NYBuilt 1954 · S/N 22-2570 N1797RNorthstar Holdings LLC · Anchorage, AKBuilt 1981 · S/N U20606331 N1797XN1797x Aero LLC · Gulf Breeze, FLBuilt 1975 · S/N 21060817 N17980Rowles Robert · Pittsfield, ILBuilt 1977 · S/N TH-840 N1798GMeaux Jimmie J Jr · Kaplan, LABuilt 1962 · S/N CD-512 N1798MWalker Steven C · Lake Havasu City, AZBuilt 1975 · S/N 18264451 N1798RSedwick Jack D III · Anchorage, AKBuilt 1974 · S/N 18502514 N1798XN1798x LLC · Etna Green, INBuilt 1975 · S/N 21060818 N1799PGranger Joshua M · Rosebud, MTBuilt 1955 · S/N 22-2572 N1799TFitzthum Eugene F Jr · Sandusky, OHBuilt 1972 · S/N 28-7325060 N179AKCrp Research LLC · Fenton, MIBuilt 2017 · S/N E-4101 N179AMNorth American Flight Services Inc · Ballston Spa, NYBuilt 2005 · S/N 2317 N179BCDenmark Ag · Winters, CAS/N 458-2004 N179BWAshmore Lance E · Rogers, ARBuilt 2008 · S/N 3029 N179CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282339 N179DHicks Jonathan · Edgewood, TXBuilt 2013 · S/N 3175 N179DCHoare Chad E · Keller, TXBuilt 2003 · S/N 4061 N179GCWolfpacc Inc · Ponte Vedra, FLBuilt 2005 · S/N 062 N179GTNeedham Charles Scott · Washington, UTBuilt 1979 · S/N AA5B-0962 N179JSMcdonald Timothy Steven · Slaton, TXBuilt 2004 · S/N 18281481 N179KDTblc LLC · Princeton, NJBuilt 1967 · S/N D-8519 N179MAAir-Knechtions LLC · Batavia, ILBuilt 2003 · S/N 260012 N179MCFulton Rick D · Marble Falls, TXBuilt 1990 · S/N CE-1530 N179NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010009 N179PCMsb Aero LLC · Middletown, DES/N 1029-2006 N179RMyers Aviation Inc · Oshkosh, WIBuilt 1978 · S/N D-10179 N179RAMorter Roger P · Hermiston, ORBuilt 2004 · S/N 1352-2003 N179SWAnthony Michael J · South Park, PAS/N 28-8016242 N179THHegedus Timothy L · Mount Ulla, NCBuilt 2012 · S/N 25789 N179TWBlue Sky Aviation Investments LLC · Coconut Creek, FLBuilt 1979 · S/N 79-30957 N179WSEbken Gary R · Loxahatchee, FLBuilt 1959 · S/N 51698 N179WZCatterton Jane S · Signal Mountain, TNBuilt 1981 · S/N 18268036 N17ABBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 21057674 N17ACPressley Brent DBA · Morristown, TNBuilt 1967 · S/N 670329 N17ADOlear Daniel J · Warren, MIBuilt 1968 · S/N 690008 N17AJJohnson Vernon G · Fort Worth, TXBuilt 2000 · S/N 589

Back to AD 2007-04-19 R1