Registered aircraft · 5,537

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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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.

N504GTBengal Investments LLC · San Francisco, CABuilt 2008 · S/N 4149 N504JBJetblue Airways Corp · Long Island City, NYBuilt 1999 · S/N 1156 N504KHFms Management Systems LLC · Dover, DEBuilt 2023 · S/N 560-6341 N504LCRegistered aircraftBuilt 2014 · S/N 1472 N504PASmee Homes Inc · Porterville, CABuilt 1988 · S/N 43 N504SNSana Capital Holdings Delaware LLC · Dover, DES/N 560-5332 N504STSdt Air Delaware LLC · Wilmington, DEBuilt 1996 · S/N 162 N504WGTextron Aviation Inc · Wichita, KSBuilt 2024 · S/N 560-6355 N504WTHerin Aviation LLC · Spring, TXBuilt 2019 · S/N 062 N505DSwift Connections LLC · Los Angeles, CABuilt 2011 · S/N 5323 N505JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1173 N505TJMercy Flight Inc · Buffalo, NYS/N 57470 N505VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4798 N505WG505wg LLC · Wilmington, DEBuilt 2024 · S/N 560-6356 N506DJJrw Falcon LLC · Staten Island, NYBuilt 2001 · S/N 158 N506HGKimberly-Clark Integrated Services Corp · Dallas, TXBuilt 2012 · S/N 5400 N506JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1235 N506TJMercy Flight Inc · Buffalo, NYBuilt 2017 · S/N 57331 N506VLBank Of Utah Trustee · Salt Lake City, UTS/N 4828 N507AYAmerican Airlines Inc · Fort Worth, TXBuilt 2008 · S/N 3712 N507DJFirm Foundation Aviation LLC · Brea, CABuilt 2001 · S/N 162 N507JTJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1240 N507VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4832 N508AYAmerican Airlines Inc · Fort Worth, TXBuilt 2008 · S/N 3740 N508BCAlta 777 LLC · Salt Lake City, UTS/N 30873 N508CKIbc Hospitality LLC · Newport Beach, CABuilt 2007 · S/N 5158 N508DJBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2001 · S/N 165 N508JLJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1257 N508MMMarklyn Jet Parts LLC · Dallas, TXFirst renewal noticeS/N 66 N508MVSdmv LLC · Danbury, CTBuilt 2023 · S/N 2317 N508RXAviation Resource Group Inc · Fort Lauderdale, FLFirst renewal noticeBuilt 2001 · S/N 195 N508TJMercy Flight Inc · Buffalo, NYBuilt 2017 · S/N 57333 N508UPCorporate Flight Management Incdba · Smyrna, TNBuilt 2005 · S/N 560-5546 N508VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4950 N508WFTmw Aviation Partners LLC · Westport, CTBuilt 2008 · S/N 4142 N509AYAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3796 N509BCJet Midwest Inc · Kansas City, MOBuilt 2003 · S/N 33370 N509JBJetblue Airways Corporation · Long Island City, NYBuilt 2000 · S/N 1270 N509KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 27659 N509TJMercy Flight Inc · Buffalo, NYBuilt 2022 · S/N 57456 N509VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5062 N50CUUnited Bottling Management Co LLC · Birmingham, ALBuilt 2022 · S/N 560-6319 N50EKLj Associates Inc · Latrobe, PABuilt 2012 · S/N 560-6112 N50HRSeminole Tribe Of Florida · Hollywood, FLBuilt 2017 · S/N 41531 N50RRTextron Aviation Inc · Wichita, KSS/N 560-6522 N50SRegistered aircraftBuilt 2008 · S/N 5216 N50WHWhite Wing Holdings LLC · Waukegan, ILBuilt 2019 · S/N 5589 N510GTSouthwest Associates LLC · Bigfork, MTBuilt 2008 · S/N 5204 N510GVTtp Services LLC · Hillsborough, NCBuilt 2006 · S/N 5106 N510JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1280

Back to AD 2012-26-15 R1