Skip to content

Registered aircraft · 106

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

N145WFAircraft Propulsion Leasing LLC · Holland, OHBuilt 1993 · S/N DC-824B N152AFUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N AC520 N158MCBemidji Aviation Services Inc · Bemidji, MNBuilt 1988 · S/N AC-726B N159MCGas/Wilson Inc · Traverse City, MIS/N AC-728B N175SWDenaina Air Taxi LLC · Anchorage, AKBuilt 1985 · S/N AC 621-B N184SWCbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-647 N211RHMcneely Charter Service Inc · West Memphis, ARBuilt 1987 · S/N AC421B N21GPKolob Canyons Air Services Inc · Wilmington, DEBuilt 1989 · S/N AC754B N227LCBemidji Aviation Services Inc · Bemidji, MNBuilt 1988 · S/N AC-707B N227LECbg LLC · Tualatin, ORBuilt 1993 · S/N DC837B N227LJMetro-Jet LLC · Downey, CABuilt 1982 · S/N AC-522 N240DHUas Transervices Inc · Boca Raton, FLS/N AT-602 N241DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-607B N244DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-618B N245DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-624B N246DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-625B N248DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-630B N249DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-631B N2691WCbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-655B N26959Bemidji Aviation Services Inc · Bemidji, MNBuilt 1986 · S/N AC-662B N2699YMcneely Charter Service Inc · West Memphis, ARBuilt 1986 · S/N AC-666 N2728GCbg LLC · Wilsonville, ORBuilt 1989 · S/N AC-731 N27442Mission Flight · El Monte, CABuilt 1989 · S/N AC750-B N3108BGas Wilson Inc · Traverse City, MIS/N AC509 N3114GM E S LLC · Anchorage, AKBuilt 1984 · S/N AC-583 N3116NBemidji Aviation Services Inc · Bemidji, MNBuilt 1984 · S/N AC-596 N31171Cbg LLC · Wilsonville, ORBuilt 1985 · S/N AC-605 N320MCMcneely Charter Service Inc · West Memphis, ARBuilt 1987 · S/N AC688 N336GWWorld Class Aviation Inc · Peachtree City, GABuilt 1994 · S/N DC860M N339GWWorld Class Aviation Inc · Peachtree City, GAS/N DC-791M N3531QNew Mountain Aviation LLC · Englewood, COBuilt 1990 · S/N AC-767B N3532QNew Mountain Aviation LLC · Englewood, COBuilt 1996 · S/N DC-887B N3533QNew Mountain Aviation LLC · Englewood, COBuilt 1999 · S/N DC-900B N354AEAmeriflight LLC · Dallas, TXBuilt 1985 · S/N AC-633 N360AEUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N AC-675 N366AEBemidji Aviation Services Inc · Bemidji, MNBuilt 1987 · S/N AC-681B N370AEAmeriflight LLC · Dallas, TXBuilt 1982 · S/N AC-506 N421MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-634 N422MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-635 N424MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-639 N425MACbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-640 N426MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-645 N428MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-646 N430MAGas/Wilson Inc · Traverse City, MIS/N AC-710B N496PTPlane Folk LLC · Klamath Falls, ORS/N AT-427 N508FACbg LLC · Wilsonville, ORBuilt 1982 · S/N AC508 N526LALiberty Alliance LLC · Tampa, FLBuilt 1994 · S/N DC-858M N527LALiberty Alliance LLC · Tampa, FLS/N DC-859M N528LALiberty Alliance LLC · Tampa, FLS/N DC861M N538KLCbg LLC · Wilsonville, ORS/N AC-538

Back to AD 2014-15-01