Skip to content

Registered aircraft · 249

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

N1002GFlying Fox Aviation LLC · Idaho Falls, IDBuilt 2000 · S/N 27-0295 N1005XSigler Lanny · Albuquerque, NMBuilt 2000 · S/N 27-0302 N1016XRadial Holdings LLC · Fort Worth, TXBuilt 2000 · S/N 27-0292 N1026CMooney Howard James Jr · Lake Wales, FLBuilt 1995 · S/N 27-0203 N1041CHelzer Timothy · Tucson, AZBuilt 2003 · S/N 270321 N1048DDumbravo Dustin C · Yorktown, VABuilt 2001 · S/N 27-0315 N1049TRoberts Kevin C · Athens, GABuilt 2003 · S/N 27-0319 N1050BNine1on Industries LLC · Helena, MTBuilt 2001 · S/N 27-0312 N1050QCouch Kelly P · Elk Grove, CABuilt 2000 · S/N 27-0310 N1065SGiacobbe Francesco · Severna Park, MDBuilt 1994 · S/N 27-0187 N1065WCartwright Alexander Brooks · New Paris, INBuilt 1994 · S/N 27-0188 N1073GProfessional Flyers Corporation · Wilmington, DEBuilt 1994 · S/N 27-0191 N1083TBaer Matthew · New York, NYBuilt 1989 · S/N 27-0023 N1084GAce 1084 LLC · Plainfield, ILS/N 27-0028 N1084UGranelli Nicholas · Sherman, TXBuilt 1995 · S/N 27-0201 N1085G3foxtrot LLC · Tucson, AZBuilt 1989 · S/N 27-0009 N1085KSummermatter Richard C · Orchard Park, NYBuilt 1989 · S/N 27-0035 N1085SConnell Curtis C · Driggs, IDS/N 27-0036 N1085WBas Part Sales LLC · Greeley, COBuilt 1990 · S/N 27-0043 N1085ZBeehive Communications Inc · Providence, RIBuilt 1990 · S/N 27-0040 N1086SDevito David E · Maple Valley, WABuilt 1990 · S/N 27-0044 N1086TDutcher Pierpont E · Bend, ORBuilt 1990 · S/N 27-0045 N1087QFairway Auto Clinic LLC · Carlsbad, NMBuilt 1990 · S/N 27-0049 N1088FRegistered aircraftBuilt 1989 · S/N 27-0019 N1088MVaeth George W · Dallas, TXBuilt 1989 · S/N 27-0020 N1088SChaney George L · Bandon, ORS/N 27-0024 N1088TSteenbergen Dale G · Cheyenne, WYBuilt 1990 · S/N 27-0050 N1089GMooney Technical Services LLC · Norfolk, VABuilt 1990 · S/N 27-0051 N1090LKeull Warren W · Needville, TXBuilt 1990 · S/N 27-0053 N1091AMooney N1091a LLC · Broomfield, COS/N 27-0062 N1091LMoonair Inc · Wilmington, DES/N 27-0063 N10KGSeek Health Pllc · Naples, IDBuilt 1998 · S/N 27-0249 N112RMAppalachian Aviation LLC · Harrisonburg, VABuilt 1998 · S/N 27-0254 N117TDGiffin Craig D · Windermere, FLBuilt 1990 · S/N 27-0074 N11HWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 270057 N11KK501 Flyhigh LLC · Maple Plain, MNBuilt 1992 · S/N 27-0122 N11ZDQualitair LLC Trustee · MichelstadtBuilt 1990 · S/N 270025 N121TDelmarva Flight Leasing Inc · East Moriches, NYBuilt 1992 · S/N 270124 N123BBSingletrack Aviation LLC · Brecksville, OHBuilt 1996 · S/N 27-0220 N123RMConstruction Imports LLC · Fleetwood, NCBuilt 1996 · S/N 27-0221 N126SCDriven Design Studio Pllc · Battle Creek, MIBuilt 1994 · S/N 270180 N129RCAirris Aviation & Marine Co · N Fort Myers, FLBuilt 1993 · S/N 27-0173 N12XLAurora Aviation LLC · Billings, MTBuilt 2004 · S/N 27-0325 N133PRJamian Corporation · Lewes, DEBuilt 1993 · S/N 27-0157 N134JFFlamingo Ridge Aviation LLC · Interlachen, FLBuilt 1993 · S/N 27-0150 N139WTCotton Business Enterprises LLC · Hummelstown, PABuilt 2000 · S/N 27-0283 N140RMMckenzie Michael C · Ventura, CABuilt 2000 · S/N 27-0287 N144EBCavu Aviation LLC · Noblesville, INBuilt 2003 · S/N 270322 N14YVN14yv LLC · Oklahoma City, OKBuilt 1995 · S/N 27-0196 N150FCHart John Jr · Vallejo, CABuilt 1992 · S/N 27-0139

Back to AD 2004-23-17