Skip to content

AD 2003-17-07 R1

Registered aircraft · 260

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-17-07-R1') 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-17-07-R1') 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-17-07-R1')
    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-17-07-R1')
  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-17-07-R1')
  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-17-07-R1')
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.

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 N781SNAtares Funding LLC · Fisher Island, FLBuilt 1998 · S/N 48781 N782TWSierra American Corp · Wilmington, DEBuilt 1967 · S/N 45826 N783SNAtares Funding LLC · Fisher Island, FLBuilt 1998 · S/N 48783 N783TWSierra American Corp · Wilmington, DEBuilt 1966 · S/N 47010 N784SNAtares Funding LLC · Fisher Island, FLS/N 48784 N784TWSierra American Corp · Wilmington, DEBuilt 1967 · S/N 47014 N797ALSkybus Jet Cargo Inc · Las Vegas, NVBuilt 1972 · S/N 46163 N799JNAtares Funding LLC · Miami Beach, FLS/N 48799 N801WACaribbean Sun Airlines Inc DBA · Miami, FLBuilt 1992 · S/N 53291 N802DHHeavylift Cargo Airlines Inc · Kingman, AZS/N 46076 N803DHHeavylift Cargo Airlines Inc · Kingman, AZS/N 46123 N804DHBjw Services Inc · Kingman, AZS/N 46091 N804SNAtares Funding LLC · Miami Beach, FLBuilt 2000 · S/N 48804 N805MLSmb Md-87 II LLC · Longwood, FLS/N 49777 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 N813TLGeoairgroup LLC · Wilmington, DES/N 45732 N8201Omega Air Inc · Selma, TXS/N 48201 N8205Omega Air Inc · Selma, TXS/N 48205 N8209Omega Air Inc · Selma, TXS/N 48209 N8222Omega Air Inc · Selma, TXS/N 48222 N82247Omega Air Inc · Selma, TXS/N 48247 N823VVOmega Air Inc · San Antonio, TXS/N 47823 N8249Omega Air Inc · Selma, TXS/N 48249 N824VVOmega Air Inc · San Antonio, TXS/N 47824 N826VVOmega Air Inc · San Antonio, TXS/N 47826 N8306Omega Air Inc · Selma, TXS/N 48306 N8308Omega Air Inc · Selma, TXS/N 48308 N8310Omega Air Inc · Selma, TXS/N 48310 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 N852VOmega Air Inc · San Antonio, TXBuilt 1980 · S/N 47852 N853VVOmega Air Inc · San Antonio, TXS/N 47853 N861GAWorld Atlantic Leasing LLC · Miami Springs, FLBuilt 1987 · S/N 49557 N865FSkybus Jet Cargo Inc · Las Vegas, NVBuilt 1969 · S/N 46088 N872SJHeavylift Cargo Airlines Inc · Kingman, AZS/N 46067 N883GAFalcon Commercial Aviation LLC · Miami, FLBuilt 1988 · S/N 49710 N887GARising Sun Aviation LLC · Irving, TXBuilt 1990 · S/N 49932 N904CETatonduk Outfitters Limited · Fairbanks, AKBuilt 1967 · S/N 47040 N9113DHeikkila Glenn R · Rockland, MAS/N 47577 N913DECorsair Two LLC · Hillsboro, ORBuilt 1993 · S/N 49956

Back to AD 2003-17-07 R1