Skip to content

Registered aircraft · 6,916

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N4043MPremier Air Charters Inc · Coram, NYBuilt 1980 · S/N 31-8152001 N40449Marsan Kenan Miles · Bethel, AKS/N 32R-7780519 N4044RFour M Aviation LLC · St Petersburg, FLBuilt 1967 · S/N 32-40342 N40454Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 27-7305167 N40464Pavco Inc · Gig Harbor, WABuilt 1973 · S/N 27-7305181 N40465Bartow Municipal Airport Development Authority · Bartow, FLBuilt 1973 · S/N 27-7305182 N40471Hamilton Christopher C · Sonoita, AZBuilt 1973 · S/N 27-7305189 N4048RHarris Heights LLC · Tyler, TXBuilt 1967 · S/N 32-40348 N404ABcj LLC · Haines City, FLBuilt 1981 · S/N 31-8252004 N404CHNorthwestern Michigan College · Traverse City, MIBuilt 1976 · S/N 27-7654191 N404WBNew England Airlines Inc · Westerly, RIBuilt 1977 · S/N 564 N40510Yonika Richard J · Northbridge, MABuilt 1973 · S/N 27-7405241 N4051WHenningsen Gregory Mark · Arvada, COBuilt 1966 · S/N 32-40071 N40522Khag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 27-7405255 N4053RDorsett Brandon · Buckeye, AZBuilt 1967 · S/N 32-40355 N40557Legacy Aviation LLC · Tea, SDBuilt 1973 · S/N 27-7405297 N40559Frost Aviation Services Inc · Las Cruces, NMBuilt 1973 · S/N 27-7405300 N4055BViking Aviation LLC · York, NEBuilt 1974 · S/N 75-32-151 N4055RBroadhurst Eric Clark · Brookline, NHBuilt 1967 · S/N 32-40358 N4055WDiehl Frances M · Alamogordo, NMBuilt 1966 · S/N 32-40079 N40566Miller Stan · Skiatook, OKBuilt 1973 · S/N 27-7305188 N40569Harvey Sawyer N · Jaffrey, NHBuilt 1974 · S/N 27-7405310 N4056WHighwing Flyers Inc · Cape May Ch, NJBuilt 1966 · S/N 32-40081 N40571Bwh Leasing LLC · Lewes, DEBuilt 1974 · S/N 27-7405313 N40578Dna Flight Ops LLC · Edgewater, FLBuilt 1974 · S/N 27-7405322 N4057RCurrier Dustan · Fairbanks, AKBuilt 1967 · S/N 32-40361 N4057W57whiskey LLC · Rowlett, TXBuilt 1966 · S/N 32-40083 N40581Chagres Aero LLC · Albuquerque, NMBuilt 1974 · S/N 27-7405325 N4058RSanders Christopher A · Escondido, CABuilt 1967 · S/N 32-40363 N4058WBrandon Sidney J III · Dundas, VABuilt 1966 · S/N 32-40085 N40599Tcb Aviation Inc · Knoxville, TNBuilt 1974 · S/N 27-7405345 N405CCLussier Michael N · Sutton, MABuilt 2006 · S/N T18208602 N405CGPinheiro Rodrigo Postal · Albuquerque, NMBuilt 1994 · S/N 27-0179 N405DBSn 0048 LLC · Wilmington, DEBuilt 2006 · S/N T20608622 N405TBPiland Donald A · Gulf Shores, ALBuilt 2006 · S/N T18208608 N405TTGramling Terry Dewayne Jr · Corinth, MSBuilt 2007 · S/N T18208768 N405WBNew England Airlines Inc · Westerly, RIBuilt 1975 · S/N 32-7640043 N4060BSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 75-31110 N4061RHorse Saddle Shop Inc · Bremen, INBuilt 1967 · S/N 32-40369 N4064RHissem John T · Castle Rock, COBuilt 1967 · S/N 32-40372 N4065RDever Brandon · Auburn, CABuilt 1967 · S/N 32-40373 N4065WGrubs Jon P · Winter Haven, FLBuilt 1967 · S/N 32-40099 N4066RMoore Arthur Douglas · Sulphur Springs, TXBuilt 1967 · S/N 32-40374 N4067RM & H Aviation LLC · Homestead, FLBuilt 1967 · S/N 32-40375 N4067WBluestone Land LLC · Charlottesville, VABuilt 1966 · S/N 32-40103 N40698Murphy Robert H · Skagway, AKBuilt 1973 · S/N 32-7440056 N4069WRoss Christian M · Bakersfield, CABuilt 1966 · S/N 32-40107 N406DZSpeedstar Aviation LLC · Kalispell, MTBuilt 1978 · S/N 31-7812051 N406LBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N T18208406 N406WBNew England Airlines Inc · Westerly, RIBuilt 1975 · S/N 32-7640058

Back to AD 71-13-01 R1