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.

N465AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52432 N467AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52438 N468RLMarks Lloyd L · Lafayette, LABuilt 1985 · S/N 51155 N469AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52480 N471AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52466 N473AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52407 N475ALScotts Helicopter Service Inc · Le Sueur, MNBuilt 1968 · S/N 6675 N477CSRegistration Pending · Spearfish, SDRegistration pendingBuilt 1994 · S/N 2045 N477SDHigh-Lead Helicopters LLC · Mossyrock, WABuilt 1990 · S/N 51343 N478CSRegistration Pending · Spearfish, SDRegistration pendingBuilt 1998 · S/N 2053 N479AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52479 N480FHFalcon Helicopters Inc · Logan, NMS/N 5009 N480MTCline Air Services LLC · Ellensburg, WABuilt 1994 · S/N 5003 N480RSEuroaviation Inc Trustee · KematenBuilt 1999 · S/N 5038 N480TTSanta Lucia Holding · Forked River, NJBuilt 1997 · S/N 5019 N481RCOrange County Sheriff'S Office · Orlando, FLBuilt 2015 · S/N 52481 N481RDSchwam Julie R · Hayden, IDS/N 6716 N482TJSky Aviation Corp · Worland, WYBuilt 1996 · S/N 52174 N4833Gm Leasing Co LLC · Broussard, LABuilt 1989 · S/N 51285 N483AEAir Evac Ems Inc · O Fallon, MOBuilt 2010 · S/N 52410 N4846G M Leasing Co LLC · Broussard, LABuilt 1987 · S/N 51200 N484AEAir Evac Ems Inc · O Fallon, MOBuilt 2010 · S/N 52411 N486AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52467 N48AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45562 N490AEAir Evac Ems Inc · O Fallon, MOBuilt 2006 · S/N 52336 N493BNStimart Rene D Trustee · Harshaw, WIBuilt 1962 · S/N 1321 N49MAAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1992 · S/N 52001 N4CQHelicopters Inc · Cahokia, ILBuilt 1994 · S/N 52088 N4KAAmbrose Group Inc · Bellevue, WABuilt 1992 · S/N 51578 N4RRBlue Sky Air Services LLC · Wilmington, DEBuilt 2013 · S/N 0203FF N500TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2019 · S/N 0320FF N5013GHmc Lift LLC · Wilmington, DEBuilt 1979 · S/N 45254 N5017GHelimontana.Com LLC · Livingston, MTBuilt 1979 · S/N 45228 N505MPCity Of Mesa Police Dept · Mesa, AZBuilt 2001 · S/N 0722FF N506MPCity Of Mesa · Mesa, AZBuilt 1998 · S/N 0541E N507MPMesa Police Dept · Mesa, AZBuilt 2015 · S/N 0226FF N513HAMagnum Aviation LLC · Goff, KSBuilt 1977 · S/N 5013 N514RLSlikker Flying Service Inc · Buttonwillow, CABuilt 1991 · S/N 51514 N516LERotor Republic LLC · Orlando, FLBuilt 1978 · S/N 45162 N5185GLas Vegas Metropolitan Police Department · North Las Vegas, NVBuilt 1984 · S/N 0009F N520HCValiair Lc Trustee · Casper, WYBuilt 1992 · S/N LN028 N520MHSilver Cloud One LLC · Reno, NVBuilt 1993 · S/N LN057 N520RLPremier Rotors LLC · Saint Martinville, LABuilt 1993 · S/N 52052 N521PAPatriot Aviation Inc · Greenville, DEBuilt 1985 · S/N 0015F N523TDTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 52388 N52GHPleasant Gap Land Co Inc · State College, PABuilt 1989 · S/N 51276 N52PLParatus Air DBA · Auburn, INS/N 45744 N530Valiair Lc Trustee · Casper, WYBuilt 2023 · S/N 0343FF N530ARN530mx LLC · Missoula, MTBuilt 2009 · S/N 0157FF N530CGSvp LLC · Tucson, AZBuilt 1987 · S/N 0041FF

Back to AD 85-25-07 R1