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.

N6634BAri Ben Aviator Inc · Fort Pierce, FLBuilt 1979 · S/N ME-234 N66352Seaplane Adventures LLC · Cheyenne, WYBuilt 1979 · S/N ME-251 N6635BChandler Jerome P · Redondo Beach, CABuilt 1979 · S/N ME-245 N6636LAoa Kissimmee Inc · Kissimmee, FLBuilt 1979 · S/N ME-256 N6636TVincent Air LLC · Carroll, IABuilt 1979 · S/N ME-259 N6638HWright Aero Inc · Saint Cloud, MNBuilt 1979 · S/N ME-266 N6697DAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME-264 N6698HNational Test Pilot School · Mojave, CABuilt 1979 · S/N ME-273 N66TPAmerican Aviation Aircraft Leasing Inc · El Cajon, CABuilt 1979 · S/N ME-164 N67000Registration Pending · Johns Island, SCRegistration pendingS/N ME-283 N6700CKelly Aviation & Investigation LLC · Vail, AZBuilt 1980 · S/N ME-275 N6701RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1980 · S/N ME-281 N6701TAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1980 · S/N ME-285 N6701VHub City Aviation Academy LLC · Lubbock, TXBuilt 1979 · S/N ME-297 N6702XFlight Time Builders Inc · Memphis, TNBuilt 1981 · S/N ME-287 N6704DScaled Composites LLC · Mojave, CABuilt 1980 · S/N ME-325 N6706YSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N ME-299 N6711GQuality Aviation Inc · Atlanta, GABuilt 1979 · S/N ME-311 N6712AMcginnis Air LLC · Rising Star, TXBuilt 1980 · S/N ME-312 N6716ZNextgen Flight Academy Inc · Riverside, CABuilt 1980 · S/N ME-328 N6720TScandinavian Aviation Academy Inc · El Cajon, CABuilt 1980 · S/N ME-335 N6752ZVector USA LLC · Olive Branch, MSBuilt 1981 · S/N ME-340 N6928HMaya Air Services LLC · Lee, NHBuilt 1983 · S/N ME-405 N700MWSome Beech LLC · Bolivar, MOBuilt 1978 · S/N ME-134 N707DJSun City Aviation LLC · Davie, FLBuilt 1980 · S/N ME-367 N7238LHorizon Flight Center LLC · Chesapeake, VABuilt 1981 · S/N ME-433 N748DAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1980 · S/N ME-341 N7603CSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N ME-230 N760AAce Aircraft Leasing Inc · Nazareth, PABuilt 1979 · S/N ME-303 N762JTPurdue University · West Lafayette, INBuilt 1981 · S/N ME-432 N7633BSo Cal Leasing LLC · El Cajon, CABuilt 1979 · S/N ME-196 N76DUL&P Of Mke LLC · Milwaukee, WIBuilt 1978 · S/N ME-52 N76MKMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N ME186 N76NKNaples Jet Management LLC · Naples, FLS/N ME-334 N76NNSale Reported · Middletown, OHSale reported, canceledBuilt 1979 · S/N ME-158 N776PAMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N ME-284 N7774TPanjab Aviation · Las Vegas, NVBuilt 1979 · S/N ME-191 N795YAirria Holdings LLC · BerlinBuilt 1979 · S/N ME-231 N800ADOkadaful LLC · Torrance, CABuilt 1978 · S/N ME-96 N800VMN800vm LLC · Wilton Manors, FLBuilt 1980 · S/N ME-318 N8013YSunking Aviation LLC · Plano, TXS/N ME-413 N808DJAeroquest LLC DBA · Olive Branch, MSBuilt 1982 · S/N ME-391 N83ERMike Smith Aviation International Inc · Rancho Murieta, CABuilt 1979 · S/N ME-201 N877SPElizabeth City State University · Elizabeth City, NCS/N ME-310 N899AVGilbert Charles L · Belleair, FLBuilt 1980 · S/N ME-353 N928EFAon-Adharc Aircraft Leasing LLC · Sellersburg, INBuilt 1979 · S/N ME-136 N969RAFox Valley Technical College · Oshkosh, WIBuilt 1980 · S/N ME-317 N96HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1978 · S/N ME-30 N976BEAero Sphere Inc · Mcclellan, CABuilt 1979 · S/N ME-252 N976CAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1979 · S/N ME228

Back to AD 80-19-12 R1