Registered aircraft · 523

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:2011-07-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:2011-07-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:2011-07-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:2011-07-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:2011-07-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:2011-07-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.

N823WWHoffman Richard D · Waterford, WIBuilt 1997 · S/N 20017 N8484Lodestar Aviation LLC · Sheridan, WYBuilt 1996 · S/N 20013 N879MPTriple K & F Flying LLC · Greenwood, MSS/N 20009 N8MTGavriilidis Gavriil · Palm Harbor, FLFirst renewal noticeBuilt 1974 · S/N 208 N900CDNational Event Entertainment Corp · New York, NYBuilt 1977 · S/N 14213 N911BMCarleton Charles A · Valdosta, GABuilt 1992 · S/N 14553 N912JHKelley Joseph S · Trophy Club, TXBuilt 1974 · S/N 228 N915JCCannata Jack P · Roselle, ILBuilt 2000 · S/N 14674 N916MV3b Aircraft Inc Trustee · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 14359 N91GMSchwartz Joel B Trustee · Glendale, AZBuilt 1977 · S/N 13184 N925RPFriel Paul Jr · Phoenixville, PABuilt 1998 · S/N 14657 N928GTD Aumeries Baudouin G · Pagosa Springs, COBuilt 1993 · S/N 14587 N928HWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 14672 N946RHMorcom Aviation Services Inc DBA · Everett, WABuilt 1977 · S/N 14223 N951JBHuddleston H Glenn · San Antonio, TXBuilt 2000 · S/N 20029 N952DGSkywatch Aviation LLC · Leesburg, VABuilt 1977 · S/N 14319 N963TBOpdyke Tod J · Concord, CABuilt 1976 · S/N 14158 N9682NOhman Chris M · Tulsa, OKS/N 14170 N969CSAerodyme Corp · South Burlington, VTBuilt 1997 · S/N 20016 N973TSOld Ocean Cattle Co LLC · Sweeny, TXBuilt 1974 · S/N 130 N976MAZephyr Ventures Inc · Wilmington, DEBuilt 1976 · S/N 13043 N999GMLowe Gary E · Pikeville, KYBuilt 1978 · S/N 14412 N999LHRossi Christopher G · Paso Robles, CABuilt 1976 · S/N 13063

Back to AD 2011-07-13