Skip to content

Registered aircraft · 2,860

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-05-03-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-05-03-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-05-03-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-05-03-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-05-03-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-05-03-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.

N43MMAircraft Holding Solutions LLC · Newark, DEBuilt 2001 · S/N 258543 N43NCCitation Encore LLC · Nashville, TNBuilt 2005 · S/N 560-0685 N43NWAirvest Partners LLC · New Bern, NCBuilt 2004 · S/N 525-0543 N43TPAircraft Holding Solutions LLC Trustee · Newark, DES/N 258628 N440BVBig Sky 205 LLC · Benbrook, TXBuilt 1997 · S/N 5250199 N440SErie Aviation LLC · Salem, ORBuilt 1991 · S/N 550-0692 N440WPBbft Aero Holdings LLC · Columbus, OHBuilt 2001 · S/N 258524 N4415WDodson International Parts Inc · Rantoul, KSS/N 229 N441PCAero Jet Aviation I Inc · Fort Lauderdale, FLBuilt 1992 · S/N 668 N442HRHotel Romeo LLC · Nichols Hills, OKBuilt 2023 · S/N 525-1158 N4434VAske Karl · Brainerd, MNBuilt 1947 · S/N D-1239 N443BCTothemoon LLC · Salt Lake City, UTBuilt 1997 · S/N 525-0189 N443EA500 Knot LLC · Granbury, TXBuilt 1996 · S/N 560-0400 N4446VSahagun Salvador G · Bothell, WABuilt 1948 · S/N D-1256 N444EAMoongate LLC · Newark, DEBuilt 2004 · S/N 550-1079 N444GFuquay Inc · New Braunfels, TXBuilt 1980 · S/N 550-0209 N444GGLipsitz Melvin Jr · Waco, TXBuilt 1994 · S/N 560-0262 N444JFBod Aviation LLC · Los Angeles, CABuilt 1999 · S/N 258431 N444RFCascadian I LLC · Bellevue, WABuilt 2001 · S/N 560-0559 N444ZHBma Leasing LLC · Greensboro, NCBuilt 1997 · S/N 560-0444 N4451VBeicker Dennie L · Hernando, MSBuilt 1948 · S/N D-1266 N446BWyckoff Steven H · Lompoc, CABuilt 1948 · S/N D-1462 N446SHAims Community College · Greeley, COBuilt 1982 · S/N 550-0341 N4473VMoeller Brian C · Stewartville, MNBuilt 1948 · S/N D-1291 N4479VRegistration Pending · Haslet, TXRegistration pendingBuilt 1948 · S/N D-1297 N447SFSeneca Foods Corp · Penn Yan, NYBuilt 2002 · S/N 550-1020 N4487VMckenna Clark J · Big Rapids, MIBuilt 1948 · S/N D-1306 N4488VRegistration Pending · Houston, TXRegistration pendingBuilt 1948 · S/N D-1307 N448LLValiair Lc Owner Trustee · Casper, WYBuilt 2007 · S/N 525-0651 N4493VWeinheimer Ethan T · Onida, SDBuilt 1948 · S/N D-1313 N44CKMile High Carpet Rides LLC · Dover, DEBuilt 2000 · S/N 525-0401 N44FRArkansas Jet Sales & Leasing LLC · Gulf Shores, ALBuilt 1981 · S/N 550-0334 N44GFCain Management LLC · Cropwell, ALBuilt 2008 · S/N 560-0791 N44HBBartowjets LLC · Wilmington, DEBuilt 1984 · S/N 437 N44JBAnb Asset Holdings LLC · Missoula, MTBuilt 2019 · S/N 525-1038 N44LVCessna 44 LLC · Indianapolis, INBuilt 1996 · S/N 560-0397 N44MBTria Entertainment LLC · Wisconsin Dells, WIBuilt 2002 · S/N 258573 N44UNHawker 258359 LLC · Dover, DEBuilt 1998 · S/N 258359 N44VSHornet Aviation LLC · Anaheim, CABuilt 2002 · S/N 525-0500 N4501VRegistered aircraftS/N D-1322 N4504VWiley Calvin · Summer Shade, KYBuilt 1948 · S/N D-1325 N450MMDcbf LLC · Aledo, TXBuilt 1991 · S/N 560-0119 N4512VDortch Steven D · La Vernia, TXBuilt 1948 · S/N D-1334 N4519VCarrell Samuel R · Knoxville, TNBuilt 1948 · S/N D-1342 N451NGOne Amigo LLC · Raleigh, NCBuilt 2022 · S/N 525-1128 N4525VMiller Grady F · Kingsland, TXBuilt 1948 · S/N D-1348 N4528VHagglund Carl D · Pendleton, ORBuilt 1948 · S/N D-1352 N4533VStraight Fly LLC · West Jordan, UTS/N D-1359 N453AMN543am LLC · Englewood, COBuilt 1982 · S/N 453 N453JGShell Mountain Ranch LLC · Cranfills Gap, TXBuilt 1991 · S/N 560-0158

Back to AD 97-05-03 R1