Registered aircraft · 737

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-16-13') 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-16-13') 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-16-13')
    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-16-13')
  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-16-13')
  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-16-13')
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.

N254DHLarson Donald J · Lillian, ALBuilt 2007 · S/N 07SC046 N255MGCentral Valley Flight School LLC · Hanford, CABuilt 2011 · S/N 087/US N2569VJohnson Ralph Timothy · Fuquay Varina, NCBuilt 2007 · S/N 07-237 N256RJHolm Russell R · Andover, MNBuilt 2007 · S/N T01045 N2570CRempel Johan B · El Paso, TXFirst renewal noticeBuilt 2007 · S/N 07-238 N2573DCoenen Lance G · North Augusta, SCS/N 03000911 N2585Harriman Merrill William · West Ossipee, NHBuilt 2019 · S/N 70507085 N258DHSwan Lake Aviation Corp · Mankato, MNBuilt 2006 · S/N 8411 N259APConsolidated Leasing And Management LLC · Lafayette, LABuilt 2021 · S/N 00141 N2605TDutt Kevin · Brentwood, CABuilt 2006 · S/N 2006-096 N260JLClover Park Technical College · Lakewood, WABuilt 2016 · S/N 176/US N262SMMagnuson D Stephen · Sheridan, WYBuilt 2015 · S/N 1298262 N264CBMccalla Richard K · Covington, TNBuilt 2015 · S/N JA418-11-14 N265JHRichardson Roger D · Hendersonville, TNS/N 1061SD N266ACGo Gyro LLC · Essex, MDBuilt 2012 · S/N 011 N266CPThooft Marlowe L · Russell, MNBuilt 2009 · S/N JAESC0147 N2698THughes Lanny A · Collierville, TNBuilt 2007 · S/N 0412 N26KBKrishnan Sunil G · San Rafael, CABuilt 2003 · S/N T03088 N26WUDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2025 · S/N VSWX121A0188 N2701DDewhurst Sebastian J · Lithia, FLBuilt 2008 · S/N 7-6631 N270CMVidovich David F · Olmsted Twp, OHBuilt 2019 · S/N 283/US N270DGRed Owl Flying Service · Los Lunas, NMBuilt 2010 · S/N 7-7166 N2729KBurnett James W · Huntsville, ALS/N 09970815 N2732AHafner Terrance W · Winter Haven, FLBuilt 2002 · S/N 000592 N2742NSizemore Albert D · Ocoee, FLBuilt 2005 · S/N T05049 N2749NAgave Aviation LLC · Austin, TXBuilt 2005 · S/N T05075 N274TATumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2014 · S/N 134/US N274TLForman Thoedore L · Westminster, MDBuilt 2025 · S/N 02220102 N2750NRusu Teofil Lucian · The Colony, TXS/N T05050 N277TTMetz Transportation LLC · Browns Valley, MNBuilt 2014 · S/N JA 359-03-14 N279DEPeter Pan LLC · Salida, COBuilt 2007 · S/N CAL02671S N280JHAirflight LLC · De Pere, WIBuilt 2006 · S/N 12051716 N280QTTruax Wesley M · Macdoel, CABuilt 2024 · S/N 256 M912 N2838AOlsen Daniel F · St George, UTBuilt 2003 · S/N A 136 PEG N2840NDucote Christopher N · Bunkie, LAS/N D98912C0HK0297 N284USGarabedian John H · Southborough, MABuilt 2009 · S/N 09SC289 N286TAMfga LLC · Smyrna, TNBuilt 2014 · S/N 136/US N287DGGardner David C · Williston, SCS/N 07010935 N291FASafety Management Training LLC · Hamburg, NYBuilt 2024 · S/N A447ULS N292CFWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 1140/US N294CMLag Drywall Inc · Hampton, GABuilt 2019 · S/N 294/US N2979AVannuil Jerry E · Holland, MIBuilt 2001 · S/N 000650 N297RHanley Mark S · Bristol, MEBuilt 2006 · S/N 711 N299TANorth Country Aero LLC · Hanover, NHBuilt 2007 · S/N JAESC0108 N29FPCaribbean Amphibian LLC · Punta Gorda, FLS/N 07-01-51-572 N302CAAviation Financial Corp · Torrance, CABuilt 2011 · S/N 070 N3035GMason Brooks Aviation LLC · Severn, MDBuilt 2023 · S/N 379 N304PBMcgehee Aviation Services LLC · Zephyrhills, FLBuilt 2008 · S/N 006 LSA N304PPArrington Ray · Jackson, MIBuilt 2024 · S/N A448ULS N304USBuiqui Aerospace Corp · Kissimmee, FLBuilt 2024 · S/N 403/US

Back to AD 2012-16-13