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.

N1933XHall Michael D · Athens, ALBuilt 1965 · S/N 18256033 N1934GAero-Tech Services Inc · Lititz, PABuilt 2006 · S/N 172S10129 N1934HMaloney Loran D · Barnhart, MOBuilt 1977 · S/N 28-7716065 N1934JN1934j LLC · Highland Lakes, NJBuilt 1976 · S/N 14025 N1934MKornetzke Jeffrey A · Lake Mills, WIBuilt 1976 · S/N 18264488 N1934PProulx Michael G · Westhampton, MABuilt 1955 · S/N 22-2685 N1934XMarshall Michael R · Collierville, TNBuilt 1965 · S/N 18256034 N1934YMack Anita · Scott Afb, ILBuilt 1964 · S/N 241 N1935LBlais Aviation Services LLC · Frisco, TXBuilt 1976 · S/N MB-797 N1935TWebboe Investments LLC · Falls Church, VABuilt 1971 · S/N 287105153 N1935YHodges William L Jr · Spotsylvania, VABuilt 1964 · S/N 289 N19369Aci Aviation LLC · Costa Mesa, CABuilt 2006 · S/N 172S10130 N1936AHead Joseph A · Fairbanks, AKBuilt 1952 · S/N 18-1770 N1936FCheek David H · Garland, TXBuilt 1979 · S/N 17273026 N1936GDowning John T · Tucker, GABuilt 1936 · S/N 6 N1936HBarts Flying Service · Storm Lake, IABuilt 1977 · S/N 28-7716066 N1936LAnderson Brian E · Edmond, OKBuilt 1976 · S/N M-1846 N1936MScott George M · Reno, NVS/N 18264489 N1936NBrown Stuart J · Anchorage, AKBuilt 1977 · S/N 18-7709070 N1936PSand Dollar Seaplanes LLC · Valentines, VABuilt 1997 · S/N 25008C N1936SMoore Christopher D · Cheyenne, OKBuilt 1964 · S/N 28-3173 N1936TN1936t LLC · Franklin Park, NJBuilt 1971 · S/N 28-7105154 N1936WDelgatto Robert G · Bellingham, WAS/N MB-599 N1936XNelson William T · Benton, KYBuilt 1965 · S/N 18256036 N19370Clanton Ronald W · Aurora, COBuilt 1968 · S/N 17257181 N1937FA2 Flight Leasing LLC · Castro Valley, CABuilt 1979 · S/N 17273027 N1937GGriffin Gerald D · Hunt, TXBuilt 1959 · S/N 18-7124 N1937HTerra Alfred Jr · Taunton, MABuilt 1977 · S/N 28-7790358 N1937KGriffin Contracting Co · Bloomfield, MOS/N 3213091 N1937LLuks George J · Crescent City, CABuilt 1976 · S/N MC-419 N1937MPoultry Not Beef LLC · Chancellor, ALBuilt 1976 · S/N 18264490 N1937PPro West Air LLC · West Point, UTS/N 22-2688 N1937TChristianson Eric L · Peoria, AZBuilt 1971 · S/N 28-7125490 N1937WMcculloch Jordan · Enfield, CTBuilt 1973 · S/N MB-600 N1937XOrtiz Marquez Ricardo A · Melbourne, FLBuilt 1965 · S/N 18256037 N1937YTirado Josue · Pembroke Pines, FLBuilt 1964 · S/N 244 N19387Debo Group Inc · Uniontown, OHBuilt 1976 · S/N 17702567 N1938ABullock Brian R · Cambridge Springs, PABuilt 1952 · S/N 18-1772 N1938LTexas Environmental Training & Compliance LLC · Frost, TXBuilt 1976 · S/N MC-414 N1939GMorgan Larry D · Blair, NEBuilt 1989 · S/N 2890107 N1939HChicas-Terrill Roger Daniel · Anaheim, CABuilt 1977 · S/N 28R-7737018 N1939LCook Kenneth T · Danielson, CTBuilt 1976 · S/N MC-418 N1939RAmos Russ · Batesville, ARBuilt 1980 · S/N 00TM N1939SFallon Timothy · Center Barnstead, NHBuilt 2005 · S/N 172S9974 N1939X1939xray LLC · Chester, SCBuilt 1965 · S/N 18256039 N1939YMcconnell Kristopher P · Nampa, IDFirst renewal noticeBuilt 1964 · S/N 246 N193ACStearman Aviation Inc · Crawford, COBuilt 1993 · S/N 365-93 N193CVarney Gary W · Turner, MES/N 2082 N193CPStillwater Aviation LLC · Winter Haven, FLBuilt 1977 · S/N 18-7709063 N193DC310 Charter LLC · Zanesville, OHBuilt 1980 · S/N 310R1885

Back to AD 2007-04-19 R1