Skip to content

Registered aircraft · 624

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:85-25-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:85-25-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:85-25-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:85-25-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:85-25-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:85-25-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.

N164AETextron Financial Corp · Wichita, KSBuilt 2018 · S/N 52494 N165AETextron Financial Corp · Wichita, KSBuilt 2018 · S/N 52495 N166AETextron Financial Corp · Wichita, KSBuilt 2018 · S/N 52496 N169RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52063 N170AMPremier Rotors LLC · Saint Martinville, LABuilt 1982 · S/N 51036 N17238Bennett Aviation LLC · Lafayette, LABuilt 1991 · S/N 51492 N173MSFlorida Keys Mosquito Control District · Marathon, FLBuilt 2000 · S/N 52256 N173RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52066 N173SJAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1981 · S/N 5170 N175HAShearer John · The Dalles, ORBuilt 1978 · S/N HA3075 N175JKJk Aviation LLC · Kerman, CABuilt 2000 · S/N 0143FF N175MSFlorida Keys Mosquito Control District · Marathon, FLBuilt 2006 · S/N 52326 N176AEAir Evac Ems Inc · Ofallon, MOBuilt 1979 · S/N 45224 N176ETSan Juan Aviation LLC · Wilmington, DEBuilt 1980 · S/N 760095 N179RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52102 N17TLTurbines Ltd · West Point, NEBuilt 1992 · S/N 51603 N17TWWhirlybird Aviation LLC · Bend, ORBuilt 1998 · S/N 52213 N1807Gm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 52361 N1808Gwinnett County Police Dept · Lawrenceville, GABuilt 2019 · S/N 0318FF N1821Gm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 52366 N183PSkytech Cc LLC · Santa Rosa Beach, FLBuilt 2000 · S/N E-3346 N18FFHeliservice LLC · Wilmington, DEBuilt 2006 · S/N 0146FF N192RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1996 · S/N 52192 N193ALBlade Leasing LLC · Homer, AKBuilt 2006 · S/N 52344 N194TAJsj Aviation LLC · Helena, MTBuilt 1991 · S/N 51542 N1957ZDakota Rotors LLC · Custer, SDBuilt 1994 · S/N 52109 N19BHAbc Helicopters Inc · Jefferson, WIBuilt 2008 · S/N 52370 N19FFHeliservice LLC · Wilmington, DEBuilt 2010 · S/N 0718FF N19HXPremier Aircraft Services LLC · Bakersfield, CABuilt 1984 · S/N 51096 N1AKMeridian Investments LLC · Anchorage, AKBuilt 2005 · S/N 52317 N1TNNorman Family Investments LLC · Greenville, TXBuilt 1993 · S/N 52031 N2009CMeridian Helicopters LLC · Broussard, LABuilt 1982 · S/N 45678 N201PAAsa Security LLC · Anchorage, AKBuilt 1992 · S/N 51567 N202MHSouthern Utah University · Cedar City, UTBuilt 1993 · S/N 52057 N202PHCoastal Air Services Inc · Panama City, FLBuilt 1983 · S/N 51076 N202TPHeartland Aviation LLC · Ada, OKBuilt 2007 · S/N 52364 N2036FBell Textron Inc · Fort Worth, TXBuilt 1995 · S/N 52123 N203EHDsl Aviation LLC · Perham, MNBuilt 1993 · S/N 52023 N203PAD H Helicopter Inc DBA · Mcminnville, ORBuilt 1991 · S/N 51462 N204USBlue Air 2 LLC · Miami, FLBuilt 1990 · S/N 51415 N205EHSacramento Executive Helicopters Inc · Acampo, CABuilt 1983 · S/N 51060 N205FCGm Leasing Co LLC · Broussard, LABuilt 1985 · S/N 51130 N205GRCentral States Helicopters Inc · Wood River, NEBuilt 1994 · S/N 52101 N2064SAgricultural Air Services LLC · Jupiter, FLBuilt 1992 · S/N 52002 N2068WChewale Inc · Beaverton, ORBuilt 1976 · S/N N.C.013 N206APInstant Security Services Inc · Wilmington, DEBuilt 1990 · S/N 51338 N206DLLauterbach Dennis · Midlothian, TXBuilt 1986 · S/N 51170 N206FCAlpha Bravo Two LLC · Fort Lauderdale, FLBuilt 2010 · S/N 52420 N206GSBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 45760 N206HXBoeing Co · Mesa, AZBuilt 2007 · S/N 06-X002

Back to AD 85-25-07 R1