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.

N407FCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1996 · S/N 53050 N407UTMed Trans Corp · Denton, TXBuilt 1996 · S/N 53036 N408AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52408 N409AEAir Evac Ems Inc · O Fallon, MOBuilt 2010 · S/N 52413 N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493 N410AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52435 N410SCAlfheim II LLC · Menomonee Falls, WIBuilt 1998 · S/N 5026 N414AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52404 N415AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52399 N416AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52403 N417AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52463 N4180FCaswell Farms · Durham, CABuilt 1991 · S/N 51469 N418AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52405 N419DHAerial Applicators Of Missouri LLC · Qulin, MOBuilt 1984 · S/N 51007 N420AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52461 N422AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52462 N423AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52423 N424AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52424 N424WCWilson Construction Co · Canby, ORBuilt 1988 · S/N 0606FF N426AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52426 N4282ZSayre Stanley · Mantua, OHBuilt 1999 · S/N 51499 N429AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52428 N429ZACoastal Air Service Inc · Panama City, FLBuilt 1980 · S/N 45375 N42FOchoco Wood Products LLC · Prineville, ORBuilt 1994 · S/N 52100 N42SLHelicopters Inc · Wilmington, DEBuilt 2008 · S/N 52377 N430AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52430 N430AGMcmahon Helicopter Services Inc · Canton, MIBuilt 1998 · S/N 49045 N430NYMcmahon Helicopter Services Inc · Canton, MIBuilt 2000 · S/N 49068 N430STHigh Performance Helicopters Corp · Crestline, CABuilt 2000 · S/N 49071 N430VPAerotrust Services Corp Trustee · Wilmington, DES/N 49005 N431AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 52441 N431HFHeliflite Shares LLC · Newark, NJBuilt 1999 · S/N 49051 N432RDAirdine LLC · San Francisco, CABuilt 2002 · S/N 5039 N4338DAce High Helos LLC · Louise, TXBuilt 1992 · S/N 51560 N434AEAir Evac Ems Inc · Lewisville, TXBuilt 2013 · S/N 52450 N435AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52446 N436AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52447 N437AEAir Evac Ems Inc · Lewisville, TXBuilt 2013 · S/N 52449 N438AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52445 N43EEHelicopters Inc · Wilmington, DEBuilt 1999 · S/N 52219 N440AEAir Evac Ems Inc · O Fallon, MOBuilt 2013 · S/N 52453 N444AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52465 N445AEAir Evac Ems Inc · O'Fallon, MOBuilt 2013 · S/N 52452 N447AEAir Evac Ems Inc · O Fallon, MOBuilt 2013 · S/N 52454 N449BAirtrust LLC - 16 - Series 16 Trustee · Sheridan, WYBuilt 1995 · S/N 23034 N449EAEdgefield Aviation LLC · Sandy, ORBuilt 1982 · S/N 51027 N453RRJetbird Aviation LLC · Conroe, TXBuilt 2007 · S/N 52356 N454AEAir Evac Ems Inc · O Fallon, MOBuilt 2013 · S/N 52460 N460AEAir Evac Ems Inc · O Fallon, MOBuilt 2013 · S/N 52456 N464AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52433

Back to AD 85-25-07 R1