Skip to content

Registered aircraft · 542

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

N161SFGm Leasing Co LLC · Broussard, LABuilt 2006 · S/N 52335 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 N16760Riggs Bobby W · Lake Mary, FLBuilt 1977 · S/N 45081 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 N173PStarflite Helicopters LLC · Beaufort, NCS/N 51370 N173RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52066 N17592Premier Rotors LLC · Saint Martinville, LAS/N 51535 N175MSFlorida Keys Mosquito Control District · Marathon, FLBuilt 2006 · S/N 52326 N176AEAir Evac Ems Inc · Ofallon, MOBuilt 1979 · S/N 45224 N178PAOrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45319 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 N1821Gm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 52366 N192AEAir Evac Ems Inc · O Fallon, MOS/N 45660 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 N19HXPremier Aircraft Services LLC · Bakersfield, CABuilt 1984 · S/N 51096 N19NGNorgreen Aviation LLC · Kirkland, WABuilt 1975 · S/N 45007 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 N20316Back Nine Aerial LLC · New Berlin, WIBuilt 1981 · S/N 45687 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 N206APInstant Security Services Inc · Wilmington, DEBuilt 1990 · S/N 51338 N206CJCb Couch Inc · Walcott, ARBuilt 1992 · S/N 51579 N206DLLauterbach Dennis · Midlothian, TXBuilt 1986 · S/N 51170 N206DRDel Rio Aviation Inc · Paso Robles, CAS/N 45180 N206EHSacramento Executive Helicopters Inc · Acampo, CABuilt 1992 · S/N 51571 N206FCAlpha Bravo Two LLC · Fort Lauderdale, FLBuilt 2010 · S/N 52420

Back to AD 2002-25-07