Skip to content

Registered aircraft · 151

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:80-19-12-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:80-19-12-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:80-19-12-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:80-19-12-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:80-19-12-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:80-19-12-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.

N5017MNo Limits Aviation Inc · Lincoln, MTS/N ME-54 N5090MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-34 N5116MBend Aircraft Mechanics LLC · Bend, ORBuilt 1978 · S/N ME-39 N5164MChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-50 N5166MSun City Aviation LLC · Davie, FLBuilt 1978 · S/N ME-46 N516MSSouth Bay Aviation Inc · Torrance, CABuilt 1979 · S/N ME-166 N5183MGc Aviation Services 1 LLC · Miamisburg, OHBuilt 1978 · S/N ME-13 N5194MSunstate Aviation Inc · Kissimmee, FLBuilt 1978 · S/N ME-17 N5236MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-21 N5283MPskd Limited LLC · Upland, CABuilt 1978 · S/N ME-25 N5485MN446rh LLC · Helena, MTBuilt 1978 · S/N ME-32 N54VBas Part Sales LLC · Greeley, COBuilt 1980 · S/N ME-313 N559MKBadawi Aviation LLC · Orlando, FLBuilt 1979 · S/N ME170 N57RTChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N ME-172 N59DLChannel Islands Aviation Inc · Camarillo, CABuilt 1979 · S/N ME-143 N6001RSorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N ME-118 N6001YPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N ME-119 N6002CChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-120 N6002KJet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N ME-122 N6002LBadawi Aviation LLC · Orlando, FLBuilt 1978 · S/N ME-123 N6003RRemikin I LLC · Naperville, ILS/N ME-126 N6003YAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-129 N6006DLedda Francesco · Canton, TXBuilt 1979 · S/N ME-133 N6011QHikari Aviation Ltd · Torrance, CABuilt 1978 · S/N ME-100 N6011UJin Jin Aviation LLC · Anchorage, AKBuilt 1978 · S/N ME-101 N6013ZVandelay Aviation LLC · San Diego, CABuilt 1978 · S/N ME-112 N60156Shannon School Of Aeronautics LLC · Fredericksburg, VABuilt 1979 · S/N ME-147 N6015QBohlke LLC · Kingshill, VIBuilt 1979 · S/N ME-141 N6015ZOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-145 N6016UAbbasi Babak · Escondido, CABuilt 1979 · S/N ME-156 N601RKNorthampton Aeronautics Inc · Northampton, MABuilt 1978 · S/N ME-71 N60244Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N ME-130 N60405Aero Quest LLC · Olive Branch, MSBuilt 1979 · S/N ME-173 N6041UCentral Virginia Aviation Inc · Petersburg, VABuilt 1979 · S/N ME-175 N6042FFly Aviation Corp · Wilmington, DEBuilt 1979 · S/N ME-176 N60451Jkg LLC · Murfreesboro, TNBuilt 1979 · S/N ME-193 N6049LExecutive Flight Institute LLC · Murrieta, CABuilt 1979 · S/N ME-202 N6199XH&S Aviation LLC · Chesapeake, VABuilt 1982 · S/N ME-437 N641PSSmith Michael J · Napa, CABuilt 1979 · S/N ME-155 N650THAri Ben Aviator Inc · Fort Pierce, FLBuilt 1982 · S/N ME-427 N6625DFox Valley Technical College · Oshkosh, WIBuilt 1979 · S/N ME-203 N66265Russo James F · Hilton Head Island, SCBuilt 1979 · S/N ME-207 N66272Fox Valley Technical College · Oshkosh, WIBuilt 1979 · S/N ME-216 N6627XIsiah 4031 LLC · Quakertown, PABuilt 1979 · S/N ME-215 N6628XAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME-218 N6628YAri Ben Aviator Inc · Ft Pierce, FLBuilt 1979 · S/N ME-219 N6632JSo Cal Leasing LLC · El Cajon, CABuilt 1980 · S/N ME-337 N6632UFox Falley Technical College · Oshkosh, WIBuilt 1980 · S/N ME-323 N66339Ave Marina Aviation Co · Long Beach, CANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-239 N66340Wickline Wayne · Flower Mound, TXBuilt 1979 · S/N ME-241

Back to AD 80-19-12 R1