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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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.

N56247Aviair Corp · Tequesta, FLBuilt 1973 · S/N 28R-7335391 N5624PCobb Jeremiah B · Colorado Springs, COBuilt 1959 · S/N 24-693 N56264Fingerlakes Aviation LLC · Marietta, NYBuilt 1975 · S/N 28R-7535212 N56283Stephens Donald K · Modesto, CABuilt 1973 · S/N 28R-7335399 N5628PMiller Space A · Simi Valley, CABuilt 1959 · S/N 24-698 N5629PVick Josh K · Brentwood, TNS/N 24-699 N562TCThekkekandam Thomas J · Greensboro, NCBuilt 1977 · S/N 32R-7880052 N56307Cjs Envol LLC · Rowayton, CTBuilt 1973 · S/N 34-7350315 N5630PWick Eric J · Three Lakes, WIBuilt 1959 · S/N 24-700 N56313Markel John E · Sussex, NJBuilt 1973 · S/N 28R-73-35407 N56317Flying Doctor LLC · Clearwater, FLBuilt 1973 · S/N 28R-7335410 N5631PNeal Brian C · Monrovia, CABuilt 1959 · S/N 24-701 N56326Abernathy Spraying Service Inc · Tipton, OKBuilt 1973 · S/N 28R7335409 N56339N56339 LLC · Lebanon, OHBuilt 1973 · S/N 28R7335414 N5633VMcwilliams Stephen C · Hollywood, MDBuilt 1977 · S/N 32R-7780349 N5634PWaters George A · Oklahoma City, OKBuilt 1959 · S/N 24-704 N56353Groux Zachary Brian · Spring, TXBuilt 1973 · S/N 28R7335418 N56355Vectair USA LLC · Olive Branch, MSBuilt 1973 · S/N 28R7335419 N56368Performance Aircraft Sales Inc · Lincoln, NES/N 34-7350322 N5637PSellman Richard · Chadron, NEBuilt 1959 · S/N 24-707 N56390Renard Jerome L Trustee · Curtis, NEBuilt 1973 · S/N 28R-7335431 N563CARegistration Pending · Wilmington, DERegistration pendingBuilt 1975 · S/N 28R-7535275 N563PJMcdonald Patrick J · Des Moines, IABuilt 1973 · S/N 28R-7335411 N563SBWalker Linda V · Zeeland, MIBuilt 1973 · S/N 28R-7335429 N56410Ehrler Andrew N · Flushing, NYS/N 28R-7335433 N56413Hupert Jason M · Grand Blanc, MIBuilt 1973 · S/N 34-7350329 N56418Shepler John E · Mobile, ALBuilt 1973 · S/N 28R7335434 N5643PRed Cardinal Aviation LLC · Chantilly, VABuilt 1959 · S/N 24-713 N56440Registration Pending · Wilmington, NCRegistration pending, pending cancellationS/N 28R7335437 N56453Richard G Trudeau LLC · Alto, TXBuilt 1973 · S/N 28R-73-35439 N5645PDeines E Jay · Wa Keeney, KSBuilt 1954 · S/N 24-715 N56461Woody Aaron Michael · Cypress, TXBuilt 1973 · S/N 28R-73-35438 N56488Pensacola Navy Flying Club Inc · Pensacola, FLBuilt 1973 · S/N 28R-73-35444 N5651PSeremet Cristina L · Beaver Dam, WIBuilt 1959 · S/N 24-722 N5651VBecker Florian Alexander · Fort Lauderdale, FLBuilt 1977 · S/N 32R-7780350 N56529Jilek Peter A · River Falls, WIBuilt 1973 · S/N 34-7350346 N5653PBeasley Charles R · Lumberton, NCBuilt 1959 · S/N 24-724 N5653VFields Shannon L · Huntsville, ALS/N 32R-7780351 N56540Schilling Aviation Services LLC · Salina, KSBuilt 1973 · S/N 34-7350347 N5654PLiebrecht Dennis L DBA · Ocala, FLBuilt 1959 · S/N 24-725 N5656PTaylor National Transportation LLC · Palatine, ILBuilt 1959 · S/N 24-727 N5658VN5658v Aviation LLC · Huntsville, TXBuilt 1977 · S/N 28R-7737067 N56598Avalos Alberto Hernandez Jr · Detroit, MIBuilt 1973 · S/N 28R-7435016 N56610Pressure Quip LLC · Houma, LABuilt 1973 · S/N 28R-7435017 N56639Doskocil Mark · Winston Salem, NCFirst renewal noticeBuilt 1973 · S/N 28R-7435021 N56652Carpenter Stephen K · El Paso, TXBuilt 1973 · S/N 28R-7435023 N56658American Aviation Inc · Brooksville, FLBuilt 1973 · S/N 34-7450019 N56668Pendarvis Damon E · Morrow, OHBuilt 1973 · S/N 28R-7435026 N5666VBross John H · Moses Lake, WABuilt 1977 · S/N 28R-7703143 N56676Paris Air Inc · Vero Beach, FLBuilt 1973 · S/N 34-7450020

Back to AD 97-01-01 R1