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.

N6038ZFlying C LLC · Oro Valley, AZBuilt 2001 · S/N 20038 N6039XInternational Air Services Inc Trustee · Carson City, NVBuilt 1995 · S/N 14639 N6042EParaken Properties LLC · Palm City, FLBuilt 2000 · S/N 20030 N6042XG & M Island Aviation LLC · Clearwater, FLBuilt 1997 · S/N 14652 N6048ABlue Sun Aviation LLC · North Syracuse, NYBuilt 1996 · S/N 14648 N6050ZJarman Patrick K · Mount Pleasant, MIBuilt 1998 · S/N 14660 N6055UThomson Mary E · San Francisco, CABuilt 2000 · S/N 14675 N6071ZJones Wayne A · Miami, FLBuilt 2001 · S/N 20041 N6081FQualitair LLC Trustee · MichelstadtBuilt 2001 · S/N 14681 N6088FAml Global Payments LLC · Cheyenne, WYS/N 20043 N6095XAlvarez Frank A · Summerville, SCBuilt 1995 · S/N 20006 N6095ZCoolidge St LLC · Prescott, AZBuilt 1976 · S/N 14005 N60963Ncommand LLC · Carencro, LABuilt 1995 · S/N 14633 N60JJGauss Karl F · Tully, NYBuilt 1976 · S/N 14175 N6105UGreggton Resources LLC · Longview, TXS/N 14625 N6106SQualitair LLC · MichelstadtS/N 14626 N6119VN6119v LLC · Boca Raton, FLBuilt 1995 · S/N 14629 N6121AMichael Lancy Architect Inc · Glendora, CABuilt 1998 · S/N 20021 N623TCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1998 · S/N 20023 N624BBPetey LLC · Lake Arrowhead, CABuilt 1997 · S/N 14651 N629CCAerotechnik Inc Trustee · Wilmington, DEBuilt 1977 · S/N 544 N654NSElks Stephen A · Mountain City, TNBuilt 1974 · S/N 133 N664HBraddock Douglas S · Limestone, TNBuilt 1999 · S/N 14664 N668SLS L Contracting Inc · Rochester, MNS/N 14668 N675KAAllis Kevin J · Columbia, MDS/N 14152 N68CAAsset Management Advisors Corp · Plantation, FLBuilt 1992 · S/N 14560 N693TCBrooks Janousek LLC · Kingsford, MIBuilt 1997 · S/N 20018 N697RHowland Justin · Pekin, ILS/N 14297 N698CACommander 1 Flight Group LLC · Wilmington, DEBuilt 1993 · S/N 14596 N7007Command Aero LLC · Newark, DEBuilt 1995 · S/N 20002 N703TGMcneil Otis · Bethlehem, PABuilt 1977 · S/N 13195 N722LWWineberg Lindsay · Beverly Hills, CABuilt 1976 · S/N 14062 N723CBPrivateflyer LLC · Lewes, DEBuilt 1978 · S/N 14398 N727CJMgr Aviation LLC · Chelsea, MIBuilt 1976 · S/N 14181 N735MCd Engineering LLC · Bennington, VTBuilt 1973 · S/N 90 N73GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 14515 N744RCAlki Investments LLC · Texarkana, TXS/N 14401 N747TXCognos Consultants LLC · East Palo Alto, CAS/N 14199 N753GMiddleton Richard P · New Port Richey, FLBuilt 1977 · S/N 520 N762DRC & J Flying LLC · Rapid City, SDBuilt 1978 · S/N 14393 N767APHorvath Patrick L · Conyers, GABuilt 1976 · S/N 14097 N768FAnderson William Keven · Mc Gregor, TXBuilt 1993 · S/N 14573 N76CRTownsend Joseph A · Buckeye, AZBuilt 1977 · S/N 13181 N76QRArmour Approach LLC · Bossier City, LABuilt 1975 · S/N 232 N771CBSkycruise Inc · Largo, FLBuilt 1978 · S/N 14378 N77717Qualitair LLC Trustee · MichelstadtBuilt 1998 · S/N 14656 N7MAWelsh Jonathan D · Montclair, NJBuilt 1992 · S/N 14559 N7PQStarr James Trey · Oklahoma City, OKBuilt 1976 · S/N 14096 N802DPGross Robert M · York, MEBuilt 2001 · S/N 14683 N823JWEllis Jeffrey Mark · Waikoloa, HIBuilt 1996 · S/N 14647

Back to AD 2011-07-13