Skip to content

Registered aircraft · 86

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

N158JPAerotrust Services Corp Trustee · Wilmington, DES/N 53195 N218JPAerotrust Services Corp Trustee · Wilmington, DES/N 53305 N438AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49456 N44503Frontera Flight Holdings Inc · Dover, DEBuilt 1989 · S/N 49797 N482AAArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49675 N483AArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49676 N553AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53083 N556AAFrontera Flight Holding Inc · Dover, DEBuilt 1991 · S/N 53086 N557ANPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53087 N558AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53088 N560AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53090 N561AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53091 N566AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49348 N572AA727x Aerospace Corp · Lewes, DES/N 49458 N573AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53092 N574AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53151 N576AAFronteraflight Holdings Inc · Dover, DES/N 53153 N581AAFrontera Flight Holding Inc · Dover, DEBuilt 1991 · S/N 53158 N583AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53160 N585AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53248 N586AAAerothrust Holdings Leasing LLC · Miami, FLS/N 53249 N590AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53253 N595AAPac Blue Aerospace · Fairbanks, AKBuilt 1992 · S/N 53285 N637SHPacific Aircorp 49741 Inc · San Francisco, CAS/N 49568 N7520AAerothrust Holdings Leasing LLC · Miami, FLS/N 49897 N7541AFrontera Flight Holdings Inc · Dover, DEBuilt 1990 · S/N 49995 N7548AFrontera Flight Holdings Inc · Dover, DES/N 53030 N7550Frontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53032 N801WACaribbean Sun Airlines Inc DBA · Miami, FLBuilt 1992 · S/N 53291 N806WA53251 LLC · Miami Springs, FLBuilt 1991 · S/N 53251 N807WAFederal Dynamics Corp · Henderson, NVBuilt 1993 · S/N 53093 N808WACaribbean Sun Airlines Inc · Miami, FLBuilt 1990 · S/N 53044 N832USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53259 N833USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53215 N834USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53115 N835USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53172 N836USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53214 N837USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53257 N842USUSA Jet Airlines Inc · Belleville, MIBuilt 1992 · S/N 53380 N861GAWorld Atlantic Leasing LLC · Miami Springs, FLBuilt 1987 · S/N 49557 N883GAFalcon Commercial Aviation LLC · Miami, FLBuilt 1988 · S/N 49710 N887GARising Sun Aviation LLC · Irving, TXBuilt 1990 · S/N 49932 N913DECorsair Two LLC · Hillsboro, ORBuilt 1993 · S/N 49956 N918AVBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 49104 N9405TFrontera Flight Holdings Inc · Dover, DES/N 53141 N9409FFronteraflight Holdings Inc · Dover, DEBuilt 1992 · S/N 53121 N948TWKc Aviation Stem Inc · Kansas City, MOS/N 49575 N950NSCorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53023 N9615WJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53562 N9616GJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53563

Back to AD 2002-09-07