Skip to content

Registered aircraft · 2,375

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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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.

N1147XPax Flyers LLC · Hollywood, MDBuilt 1975 · S/N 28R-7535259 N115DCLong Jerry D · Solvang, CABuilt 1973 · S/N 28R-7335405 N1160XWagner Robert J · Dubuque, IABuilt 1975 · S/N 28R-7535261 N1164XRegistered aircraftBuilt 1975 · S/N 28R-7535263 N1168HKoplow Steve Alan · Sevierville, TNS/N 28R-7703015 N116FRCloverfield Aero LLC · Los Angeles, CABuilt 2014 · S/N 2844150 N1179XDesch Edward J III · Aldie, VABuilt 1975 · S/N 28R-7535267 N117MBLittmarck Svante · Dedham, MABuilt 2014 · S/N 2844151 N117RKAlon Guy · El Paso, TXBuilt 1979 · S/N 28R-7931068 N117SCJenkins Matthew A · Bend, ORS/N 28R-7703343 N1188XSteven H Baker Construction Co · Big Bear City, CABuilt 1975 · S/N 28R-7535274 N1194HCrnic Paul C · Chesterfield, MOS/N 28R-7703016 N119GGYepes Hurtado Andres F · Lubbock, TXBuilt 1978 · S/N 28R-7931008 N11CWJabez Aviation LLC · Petaluma, CABuilt 1977 · S/N 28R7737079 N11JUPottorff Gregory K · Wayne City, ILBuilt 1973 · S/N 28R-7335374 N11RPN11rp LLC · Brecksville, OHBuilt 1978 · S/N 28R-7803241 N11RRRichardson Randy R · St Thomas, VIS/N 28R-7803076 N120CDJackson Farms Callahan Division LLC · Callahan, FLBuilt 1974 · S/N 28R-7435315 N1216TOlsen Christopher D · Bothell, WABuilt 1972 · S/N 28R-7235238 N1217TSauer Roger A · Glenburn, NDBuilt 1972 · S/N 28R-7235239 N121DBTexins Flying Club · Mckinney, TXBuilt 1972 · S/N 28R-7335024 N121WSOrtiz Ramon E · Spring Branch, TXBuilt 1978 · S/N 28R-7803340 N1227TStieper David Paul · Forest Lake, MNBuilt 1972 · S/N 28R-7235241 N122MCShouk Aviation LLC · Waverly, OHBuilt 2007 · S/N 2844133 N1236TOtero Edgardo A · Tucson, AZBuilt 1972 · S/N 28R-7235244 N124FVEuroaviation Inc Trustee · KematenS/N 28R-7931078 N124MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 2844092 N1253TDellemonoche Dennis R · Tabernacle, NJBuilt 1972 · S/N 28R-7235247 N1254HSherer Scott · Franklin, WIBuilt 1976 · S/N 28R-7703018 N1254TStewart Doug A · Indianola, NEBuilt 1972 · S/N 28R-7235248 N125MTMcdonald Theresa C · Beaufort, SCS/N 2844093 N1272TMyers Brent A · Palm Bay, FLBuilt 1972 · S/N 28R-7235252 N1273HCrabtree Robert E · Lookout Mountain, TNS/N 28R-7703019 N127MTPilotsplane LLC · Boca Raton, FLBuilt 2003 · S/N 2844094 N1280TCertified Equipment Inspections LLC · Washington, PABuilt 1972 · S/N 28R-7235253 N129EWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N 28R7335265 N129SAUnlimited Vertical LLC · Milton Freewater, ORS/N 28R-7737053 N12PJLarrabee Joey S Trustee · Holyoke, COBuilt 1979 · S/N 28R-7931105 N130DGDixie Aviation LLC · Pelham, ALBuilt 1972 · S/N 28R-7235127 N130TLynch Machining LLC · North Vernon, INBuilt 2003 · S/N 2844104 N1318HEvern Properties LLC · Kalispell, MTS/N 28R-7703022 N1334TCrt Aviation LLC · Clarkston, MIBuilt 1972 · S/N 28R-7235263 N133CBBrown Milton S III · Raleigh, NCBuilt 1974 · S/N 28R-7435318 N1341TShuman Cecil R Trustee · Chugiak, AKBuilt 1972 · S/N 28R-7235264 N1342TCrewdawg Aviation LLC · Concord, NCBuilt 1972 · S/N 28R-7235265 N1347HKapp Dean R · New Berlin, WIS/N 28R-7703023 N1349TMjl Flyers LLC · Somerset, PABuilt 1972 · S/N 28R-7235266 N1354TRiverside Flight Academy Inc · Riverside, CABuilt 1972 · S/N 28R-7235268 N135DGSg Solutions LLC · Reno, NVBuilt 1977 · S/N 28R-7803122 N1360TDibrino Ruth G · Hillsboro, ORBuilt 1972 · S/N 28R-7235269

Back to AD 82-06-11 R1