Registered aircraft · 2,862

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.

N508YVDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 573 N50BHTravel Link LLC · Vienna, VABuilt 1982 · S/N 359 N50BLBnb LLC · Wilmington, DES/N 2 N50CMWizard Aviation LLC · Redding, CABuilt 2004 · S/N 560-0661 N50ELSesa Aviation LLC · Weslaco, TXBuilt 1989 · S/N 5600036 N50FGRegenerative Sports Tissue Bank Inc · Lawrenceville, GABuilt 1988 · S/N 187 N50FNGh Equipment LLC · Wilmington, DEBuilt 1976 · S/N 070 N50KLLiberty Leasing V LLC · Melbourne, FLBuilt 2004 · S/N 258671 N50LQCu V LLC · Stuart, FLBuilt 1996 · S/N 560-0347 N50MReese Dave A · Capistrano Beach, CABuilt 1993 · S/N 525-0031 N50PCSpritle LLC · Chicago, ILBuilt 2000 · S/N 308 N50SNFirst Quality Falcon LLC · Great Neck, NYBuilt 2000 · S/N 310 N50USN50us LLC · New Orleans, LABuilt 1991 · S/N 560-0145 N50VSCitation Time LLC · Seguin, TXBuilt 1980 · S/N 550-0181 N50WRfbc LLC · Macon, GAS/N 550-0884 N50YPVillages Equipment Co · Leesburg, FLBuilt 2005 · S/N 344 N50YTInternational Aviation Technical Services Inc · Torrance, CABuilt 1996 · S/N 269 N510CNC & N Aviation LLC · Coshocton, OHBuilt 2006 · S/N 550-1124 N510FROneflight International Inc · Englewood, COBuilt 1984 · S/N 446 N510GPCentral Virginia Aviation Inc · Petersburg, VABuilt 1982 · S/N 550-0421 N510JCMiller Timber Services Inc · Philomath, ORBuilt 1980 · S/N 550-0197 N510JNCu IV LLC · Stuart, FLBuilt 1995 · S/N 560-0295 N510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEBuilt 1984 · S/N 140 N511ABSl Jet LLC · Franklin, NCBuilt 1981 · S/N 550-0299 N511ECMississippi Air Express LLC · Madison, MSBuilt 1993 · S/N 525-0013 N511FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 122 N511JCIntermodal Air LLC · Frankfort, ILBuilt 2001 · S/N 258518 N511TCBam Aviation Of New York LLC · Sanford, FLBuilt 1994 · S/N 525-0074 N5123Tpi Aircraft Interiors LLC · New Bern, NCBuilt 1984 · S/N 123 N512JCCarr Air LLC · Cornelius, NCBuilt 2001 · S/N 258556 N512WCCarr Air LLC · Cornelius, NCBuilt 2002 · S/N 258595 N513BEH800 IV LLC · Stuart, FLBuilt 2000 · S/N 258471 N513RV1551 Leasing LLC · Placida, FLBuilt 2003 · S/N 525-0513 N513SKHappy Skies LLC · Dover, DEBuilt 2004 · S/N 338 N514CKKenvic Aviation LLC · De Armanville, ALBuilt 2021 · S/N 525-1096 N514DSLugo Jose E Jr · Donna, TXBuilt 1998 · S/N 525-0255 N514JAAb Southwest Properties LLC · O Fallon, MOBuilt 2014 · S/N 525-0859 N515MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 550-0899 N516CJTotal Aviation Corp · Garden City, NYBuilt 1980 · S/N 016 N516KMPico Cellular Communications Inc · Key Largo, FLBuilt 2015 · S/N 525-0868 N516THHippo Air LLC · Grants Pass, ORBuilt 1999 · S/N 258418 N518NGtt LLC · Panama City Beach, FLBuilt 1987 · S/N 550-0563 N518RCBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 525-0516 N518TXSav Aviation LLC · Jacksonville, TXBuilt 1993 · S/N 560-0222 N519RJAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 550-0194 N519VPCatalyst Aviation II LLC · Pensacola, FLBuilt 2002 · S/N 550-1019 N51CFive One Charlie LLC · Fayetteville, ARBuilt 2000 · S/N 525-0400 N51FNGh Equipment LLC · Dover, DEBuilt 1976 · S/N 069 N51GNPowell Construction Company Inc · Johnson City, TNBuilt 1999 · S/N 525-0317 N51NDN51nd Holding LLC · Palm City, FLBuilt 1996 · S/N 560-0364

Back to AD 97-05-03 R1