Skip to content

Registered aircraft · 215

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

N12028American Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6456 N1630ABank Of Utah Trustee · Salt Lake City, UTS/N 1630 N177XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 2836 N1805ABank Of Utah Trustee · Salt Lake City, UTS/N 1805 N226VLSetna Io LLC · Lincolnshire, ILS/N 2264 N285GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 1936 N3014RAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5842 N301NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2319 N302NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2387 N305NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2398 N306NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2420 N307NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2427 N308NVSunrise Asset Management LLC · Las Vegas, NVS/N 2450 N309NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3084 N311NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2702 N312NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2289 N313FTUmb Bank Na Trustee · Salt Lake City, UTS/N 2313 N313NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2300 N315NVSunrise Asset Management LLC · Las Vegas, NVS/N 2412 N316NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2481 N318NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2492 N319NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2503 N320NVSunrise Asset Management LLC · Las Vegas, NVS/N 2514 N321NVSunrise Asset Management LLC · Las Vegas, NVS/N 2527 N322NVSunrise Asset Management LLC · Las Vegas, NVS/N 2528 N323NVSunrise Asset Management LLC · Las Vegas, NVS/N 2538 N324NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2709 N325NVSunrise Asset Management LLC · Las Vegas, NVS/N 2729 N326NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2586 N327NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2556 N328NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2821 N329NVSunrise Asset Management LLC · Las Vegas, NVS/N 2876 N330NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2786 N331NVSunrise Asset Management LLC · Las Vegas, NVS/N 2625 N332NVSunrise Asset Management LLC · Las Vegas, NVS/N 2638 N334NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2831 N335NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2852 N337NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2170 N338NVSunrise Asset Management LLC · Las Vegas, NVS/N 2378 N3618FPharmair Corp · Miami, FLBuilt 2006 · S/N 2748 N4005XAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5753 N4032TAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6644 N410ACBank Of Utah Trustee · Salt Lake City, UTS/N 3045 N422AVUmb Bank N A Trustee · Salt Lake City, UTBuilt 2010 · S/N 4200 N4866UUnited Airlines Inc · Chicago, ILS/N 2404 N4888UBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3258 N5007EAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5781 N519AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5119 N524VAN524va Trust · Wilmington, DEBuilt 2007 · S/N 3204 N527NKGryphon Trading Company LLC · Fort Lauderdale, FLBuilt 2007 · S/N 2978

Back to AD 2013-17-02