Registered aircraft · 702

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

N153DSDowning Lamiere J · Riner, VABuilt 2005 · S/N 40.564 N154DSIn Flight Aircraft LLC · Howell, MIBuilt 2004 · S/N 40.461 N155UUtah State University · Logan, UTBuilt 2025 · S/N 40.1251 N156PSSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 40.492 N156UUtah State Univeristy · Logan, UTBuilt 2025 · S/N 40.1252 N157UUtah State University · Logan, UTBuilt 2025 · S/N 40.1253 N158UUtah State University · Logan, UTBuilt 2025 · S/N 40.1254 N159UUtah State University · Logan, UTBuilt 2025 · S/N 40.1255 N162GLBoulder Aviation Partners LLC · Boulder, COBuilt 2012 · S/N 40.1162 N165ASVl Aviation LLC · Saint Petersburg, FLBuilt 2006 · S/N 40.702 N165PSPhindogair LLC · Lubbock, TXBuilt 2005 · S/N 40.523 N166GAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N 40.369 N166JPBaby Bird Aviation LLC · Sarasota, FLBuilt 2005 · S/N 40.502 N1707SUtah State University · Logan, UTBuilt 2005 · S/N 40.509 N170DSSmith Mountain Lake Flying Club LLC · Hardy, VABuilt 2005 · S/N 40.465 N170MAEarle George W · Spring, TXBuilt 2003 · S/N 40.272 N171CBBennett Christopher D Trustee · Cupertino, CABuilt 2008 · S/N 40.969 N171PSDiamond Air LLC · Salem, VABuilt 2006 · S/N 40.701 N171SFStratusfire LLC · St Charles, ILBuilt 2005 · S/N 40.494 N172MZ720 Aviation LLC · Spokane Valley, WABuilt 2006 · S/N 40.730 N173JPRochin Eric M · Malibu, CABuilt 2005 · S/N 40.486 N173MAStellar Aviation LLC · Benton, KYBuilt 2003 · S/N 40.292 N173RSShining Ventures LLC · Houston, TXBuilt 2003 · S/N 40.336 N175DACreative Aviation LLC · Florence, SCS/N 40.1101 N179DSWright Brother Aviation LLC · La Verne, CABuilt 2003 · S/N 40.279 N181DFDevil Dog Energy LLC · Hemet, CABuilt 2004 · S/N 40.382 N181DSBuckingham Michael J · La Jolla, CABuilt 2004 · S/N 40.403 N187DSSfl Enterprises LLC · Speedwell, VABuilt 2005 · S/N 40.574 N190MALightning Aviation LLC · Gillette, WYBuilt 2004 · S/N 40.355 N192DSRmg Aviation LLC · Bal Harbour, FLBuilt 2005 · S/N 40.576 N192LAMagnum Securities LLC · Sarasota, FLBuilt 2015 · S/N 40.1192 N193CAVision Air Leasing LLC · Newport Beach, CABuilt 2006 · S/N 40.687 N193JPMullan John C · Edina, MNBuilt 2003 · S/N 40.293 N194TSUtah State University · Logan, UTBuilt 2008 · S/N 40.972 N197DSHanover LLC · London, KYBuilt 2005 · S/N 40.586 N202LSKsx Aviation Services LLC · San Francisco, CABuilt 2004 · S/N 40.459 N203DSSouth Mountain Aero LLC · Myerstown, PABuilt 2002 · S/N 40.203 N203TSQualitair LLC Trustee · MichelstadtS/N 40.973 N203USSalter Equipment Leasing LLC · Natchitoches, LABuilt 2008 · S/N 40.903 N204SGSquillace Daniel J · Cary, NCBuilt 2005 · S/N 40.482 N205DSUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 2002 · S/N 40.205 N208DSMcshane Family Aviation LLC · Harrisburg, PABuilt 2005 · S/N 40.587 N209ASCherokee Bill Aerovation LLC · Gainesville, GABuilt 2005 · S/N 40.554 N209DSMassman Enterprises LLC · River Hills, WIBuilt 2004 · S/N 40.409 N20HJSound Aviators LLC · Bothell, WAS/N 40.937 N211WPWamware Ltd · Santa Barbara, CABuilt 2008 · S/N 40.922 N212CSummit Aviation Inc · Belgrade, MTBuilt 2011 · S/N 40.1104 N213DSLexington Flying Club Inc · Lexington, KYBuilt 2004 · S/N 40.360 N214PDN214pd LLC · Manakin Sabot, VABuilt 2008 · S/N 40.1018 N215DSArm Financial LLC · Annandale, VABuilt 2007 · S/N 40.829

Back to AD 2007-11-21