Registered aircraft · 2,132

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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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.

N1004PVankirk Malcolm R · Frederick, MDBuilt 1954 · S/N 23-6 N1008NK W Racing LLC · Angola, INBuilt 1973 · S/N 27-7305152 N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431 N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050 N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196 N100LYLyon Aviation Inc · Pittsfield, MAS/N 31-8052064 N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019 N100XRTomsis Corp · Panama City, FLBuilt 1981 · S/N 31-8152169 N100YGAnderton Doyle M · Royse City, TXS/N 31P-7530010 N1017PZeivogel Jeanine · Gulf Shores, ALBuilt 1954 · S/N 2319 N101HHElmhurst Holdings LLC · East Rochester, NYBuilt 1980 · S/N 27-8054057 N101MAPablo Air Charters LLC · New Freedom, PABuilt 1977 · S/N 31-7752186 N101NWVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1961 · S/N 27-475 N101PLHay William G Jr · Gualala, CAS/N 27-7754156 N101SLSweet Potato Flying Club LLC · Kalamazoo, MIBuilt 1959 · S/N 23-1832 N101UAReichard David Elijah · Breinigsville, PABuilt 1960 · S/N 23-1950 N102TMJunior Fernando Sporleder · Sarasota, FLBuilt 1976 · S/N 31-7712015 N102WHStuddiford James A · Lithia, FLS/N 31-7952066 N102WMStar Air Service LLC · Jacksonville, FLBuilt 1981 · S/N 31-8152112 N1033PProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 23-35 N1033TManzo Deborah S · Lake Placid, FLBuilt 1973 · S/N 27-7405302 N1036LN1036l Corp · Wilmington, DEBuilt 1976 · S/N 27-7654135 N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202 N103GLNaylor Aviation LLC · Columbia, MOBuilt 1978 · S/N 31-7912023 N103RSZielke Michael M · Chuluota, FLBuilt 1957 · S/N 23-1165 N104MQL C Whitford Co Inc · Wellsville, NYBuilt 1979 · S/N 31-7952210 N105CHMach Tuck LLC · Daytona Beach, FLBuilt 1974 · S/N 27-7405419 N105EBHardy Randall B · Argyle, TXBuilt 1956 · S/N 23-460 N105MAMorrison Andrew · Haverford, PABuilt 1980 · S/N 31T-8104015 N1065PChisum Robert · Lorenzo, TXS/N 23-75 N106JLMusic City Air LLC · Rogersville, ALBuilt 1963 · S/N 27-2416 N106REColorado Aircraft Corp · Watkins, COS/N 31-7752056 N1071AOcean Group LLC · Plantation, FLBuilt 1979 · S/N 31-7952195 N1071PFlying Circus Aircraft LLC · Manitou Beach, MIBuilt 1954 · S/N 23-82 N107PAPacific Fleet Aviation LLC · Rochester, NYS/N 27-7854002 N10853St Johns Marine DBA · San Mateo, FLS/N 277854024 N1089PDetert Bradley · Valparaiso, INBuilt 1954 · S/N 23-98 N108ACKaplan Steven M · Key Largo, FLBuilt 1983 · S/N 31-8312014 N108BHEmt Bahamas Holdings LLC · Greer, SCS/N 31-214 N108JLStar Marianas Aviation School Inc · Saipan, MPBuilt 1983 · S/N 31-8352028 N108UCHot Springs Flyers Inc · Covington, LABuilt 1979 · S/N 31T-8020018 N109CCTrans-Caribbean Air Exp & Imp Inc · Miami, FLBuilt 1968 · S/N 27-4024 N109FCUsda Forest Service Fepp · Tallahassee, FLBuilt 1980 · S/N 31-8012073 N10QBAsc Aviation LLC · Brandon, MSBuilt 1978 · S/N 31-7812065 N10YCToyz Aviation LLC · Worthington, KYBuilt 1979 · S/N 31-8012002 N10YDDavenport Jimmy J · Hayesville, NCBuilt 1965 · S/N 27-2892 N1116PSale Reported · Scottsville, VASale reportedBuilt 1955 · S/N 23-126 N111CFGsm Tax & Insurance Inc · Naples, FLBuilt 1976 · S/N 31-7652105 N111DLCresence LLC · Port Saint Lucie, FLBuilt 1976 · S/N 27-7654167 N111GAGeorges Aviation Services Inc · Honolulu, HIBuilt 1981 · S/N 31-8152050

Back to AD 2009-13-06 R1