Registered aircraft · 29

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:2003-16-51') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-16-51') 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:2003-16-51')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-16-51')
  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:2003-16-51')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-16-51')
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.

N106BRMarshall Michael A · Hanover, MDBuilt 2003 · S/N 381 N117GVTexas Soaring Association Inc · Midlothian, TXBuilt 1998 · S/N 181 N125DDArnold William · Pipersville, PABuilt 1996 · S/N 103 N142TBBig Sky Jet Inc · Bozeman, MTS/N 386 N161AFUsaf Academy · Usaf Academy, COBuilt 2003 · S/N 384 N162AFUsaf Academy · Usaf Academy, COBuilt 2003 · S/N 385 N175DDMinden Soaring Club Inc · Genoa, NVBuilt 1998 · S/N 175 N1811WMorgan Robert · Tehachapi, CABuilt 2000 · S/N 262 N215SHHall Morgan R · Los Osos, CABuilt 1999 · S/N 215 N241MZStewart Scot T · Saratoga Springs, NYBuilt 1999 · S/N 240 N268MPMarcus Hook Glider Works · Wilmington, DEBuilt 2007 · S/N 526 N369DDNephelenv LLC · Minden, NVS/N 223 N461BHDingess James David · Carson City, NVS/N 556 N483KSBarber Piet Edward · South Riding, VABuilt 2002 · S/N 358 N484KSStriedieck Karl · Dover, DEBuilt 2015 · S/N 679 N517DXDelta X-Ray LLC · Indianapolis, INS/N 517 N533BGGuerin Marianne · Lafayette, CABuilt 2007 · S/N 533 N57CGChicago Glider Club · Minooka, ILBuilt 1999 · S/N 217 N60BPHarris Hill Soaring Corp · Horseheads, NYBuilt 2003 · S/N 380 N617TBuenafe Constance · Santa Fe, NMS/N 210 N620JFDuo D LLC · Salem, VABuilt 2025 · S/N 004 N65SFEaglewings LLC · Earlysville, VABuilt 2005 · S/N 460 N65VLBuenafe Constance A · Santa Fe, NMBuilt 2001 · S/N 317 N678GBJ2j LLC · Cheyenne, WYBuilt 2016 · S/N 678 N721DDMcdowell Samuel · Carlsbad, NMS/N 177 N909BBFour Delta Tango LLC · Wilmington, DEBuilt 2005 · S/N 465 N90BPPhiladelphia Glider Council Inc · Hilltown, PABuilt 2004 · S/N 414 N982KAAlley Lynn D · Bountiful, UTBuilt 1998 · S/N 163 N990DDGibbons Robert C · Richardson, TXBuilt 2025 · S/N 005

Back to AD 2003-16-51