Registered aircraft · 13,311

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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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:2012-10-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
  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:2012-10-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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.

N111LKBrewer Mike R · Cameron Park, CABuilt 1955 · S/N G-724 N111MHHodosh Productions Inc · Santa Monica, CABuilt 2023 · S/N 9070 N111MUSag Phoenix LLC · Sagaponack, NYBuilt 2026 · S/N 11397 N111NChadwick Aviation Two LLC · West Harrison, NYBuilt 2025 · S/N 10694 N111NEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2784 N111NMHineman Land & Cattle Inc · Scott City, KSBuilt 1984 · S/N 46-8508006 N111PCWright Aviation LLC · Molalla, ORBuilt 1999 · S/N EA-639 N111PJG&L Aviation Services LLC · Las Vegas, NVBuilt 1981 · S/N 340A1234 N111RBClear Skies LLC · Allentown, PABuilt 1978 · S/N 340A0545 N111SHRobinson Doyle K · Panhandle, TXBuilt 1976 · S/N 21061270 N111TTLand Of Lincoln Aviators LLC · Chicago, ILBuilt 2004 · S/N 0830 N111VFCottle John A DBA · Watsonville, CABuilt 1980 · S/N 21064005 N111VSSite Development Inc · Mount Laurel, NJBuilt 1995 · S/N 29-0048 N111WSM20r LLC · Centennial, COBuilt 2003 · S/N 29-0290 N111XXBay Area Flying Service LLC · Burlingame, CABuilt 1983 · S/N TH-1389 N1120CBuckley Dennis P · Pawleys Island, SCBuilt 2001 · S/N E-3388 N1122BBonanza 1122b LLC · Lake Havasu City, AZBuilt 1979 · S/N EA-2 N1122YD&P Beech Aviation LLC · Concord, CABuilt 1982 · S/N EA-333 N1122ZK A Lafferty Inc · Cape May, NJBuilt 1996 · S/N E-3022 N1123UTroy Investment Co 1 L P · Brownsville, TXBuilt 1982 · S/N 21064667 N1123VLizarraga Tony Claude · Truckee, CABuilt 1997 · S/N E-3080 N1123XBeacon International Inc · Dover, DES/N 1214 N1124LAkb Aviation LLC · Las Vegas, NVBuilt 2014 · S/N 0711 N1127JG36 Holdings LLC · Sioux Falls, SDBuilt 1996 · S/N E-3027 N1127RSwan Aviation LLC · Columbia Heights, MNBuilt 2005 · S/N 1510 N1128CGibbs Wyatt R · Lodi, CABuilt 1978 · S/N 21062711 N1128RPeninsula Research LLC · San Carlos, CABuilt 2021 · S/N 2338 N1128TMccauley Mcdonald Investments Inc · Eastover, NCBuilt 1996 · S/N E-3028 N1129WSilver Wing Aviation LLC · Wilmington, DEBuilt 1997 · S/N TH-1809 N112CDRustam Ali Wings Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11457 N112EWKerwin Patrick C · Redwood City, CABuilt 1974 · S/N 21060504 N112FSFl Co-Owners #1 LLC · Roseville, CABuilt 2023 · S/N 9497 N112LFBeachcomber Run LLC · Winston Salem, NCBuilt 2016 · S/N 1393 N112LJJohnson Lenny · Baton Rouge, LABuilt 2024 · S/N 10353 N112MKTen Lakes Holdings LLC · Eureka, MTBuilt 2023 · S/N 9282 N112NRTkg Aviation LLC · Denver, COBuilt 2011 · S/N 0227 N112PJHappy Trailer Sales LLC · Palmer, TXBuilt 2017 · S/N 1540 N112SKCirrus Sr22 4821 Inc Trustee · Wilmington, DEBuilt 2019 · S/N 4821 N112TDBigsky 157 LLC · Missoula, MTBuilt 2025 · S/N 10470 N112TRBagdasarian Walter DBA · El Cajon, CABuilt 2010 · S/N 3669 N112WGGriswold Aviation LLC · San Clemente, CABuilt 2024 · S/N 9785 N112WWAmerican Smooth Aviation LLC · Rock Hill, SCFirst renewal noticeBuilt 1977 · S/N 310R1215 N1130QHedges William S · Algona, IABuilt 1997 · S/N EA-598 N1132UMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 21064669 N1133APedota Darien · Northport, ALBuilt 1980 · S/N CE898 N1134ABeaver Creek Aviation LLC · Clinton, OKBuilt 1997 · S/N E-3066 N1134WAbs Aviation LLC · Cleveland, TNFirst renewal noticeBuilt 1997 · S/N E-3067 N1134XWard Bernard Holman III · Wichita Falls, TXBuilt 1997 · S/N E-3074 N1136NPga Re LLC · Midland, TXBuilt 1996 · S/N E-3053 N1136PBjmj LLC · Greensboro, NCBuilt 1996 · S/N E-3044

Back to AD 2012-10-13