Skip to content

Registered aircraft · 194

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-14-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:2003-14-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:2003-14-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:2003-14-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:2003-14-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:2003-14-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.

N10112Kc Aviation Stem Inc · Kansas City, MOS/N 193L1064 N119NAUnited States Government · Washington, DCBuilt 1989 · S/N 24487 N12109United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27299 N12114United Airlines Inc · Chicago, ILBuilt 1995 · S/N 27556 N12116United Airlines Inc · Chicago, ILBuilt 1996 · S/N 27558 N12125United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28967 N13110United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27300 N13113United Airlines Inc · Chicago, ILBuilt 1995 · S/N 27555 N13138United Airlines Inc · Chicago, ILBuilt 1999 · S/N 30351 N140SCOrbital Sciences LLC · Mojave, CABuilt 1974 · S/N 193E1067 N14102United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27292 N14106United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27296 N14115United Airlines Inc · Chicago, ILBuilt 1995 · S/N 27557 N14118United Airlines Inc · Chicago, ILBuilt 1997 · S/N 27560 N14120United Airlines Inc · Chicago, ILBuilt 1997 · S/N 27562 N14121United Airlines Inc · Chicago, ILBuilt 1997 · S/N 27563 N144DCL-3 Capital LLC · Kalispell, MTBuilt 1982 · S/N 22191 N17104United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27294 N17105United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27295 N17122United Airlines Inc · Chicago, ILBuilt 1997 · S/N 27564 N17126United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27566 N17128United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27567 N17139United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30352 N172AJWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 32400 N18112United Airlines Inc · Chicago, ILBuilt 1995 · S/N 27302 N18119United Airlines Inc · Chicago, ILBuilt 1997 · S/N 27561 N182ANAersale Inc · Coral Gables, FLBuilt 1999 · S/N 29592 N189ANWyatt Aerospace LLC · Chandler, AZBuilt 2001 · S/N 32383 N190AAWyatt Aerospace LLC · Chandler, AZBuilt 2001 · S/N 32384 N19117United Airlines Inc · Chicago, ILBuilt 1996 · S/N 27559 N19130United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28970 N19136United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29285 N19141United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30354 N191ANWyatt Aerospace LLC · Chandler, AZBuilt 2001 · S/N 32385 N193ANWilmington Trust Company Trustee · Wilmington, DEBuilt 2001 · S/N 32387 N196AAWyatt Aerospace LLC · Chandler, AZBuilt 2001 · S/N 32390 N199ANAersale Inc · Doral, FLBuilt 2001 · S/N 32393 N21108United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27298 N226GL-3 Capital LLC · Kalispell, MTBuilt 1992 · S/N 25491 N286GBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 26245 N29124United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27565 N29129United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28969 N31019Save A Connie Inc DBA · Kansas City, MOBuilt 1974 · S/N 193B-1066 N33103Umb Bank Na Trustee · Salt Lake City, UTBuilt 1994 · S/N 27293 N33132United Airlines Inc · Chicago, ILBuilt 1998 · S/N 29281 N336QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 1506 N34131United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28971 N34137United Airlines Inc · Chicago, ILBuilt 1999 · S/N 30229 N41135United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29284 N41140United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30353

Back to AD 2003-14-21