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.

N530FFUtah Aviation Services Inc · Spanish Fork, UTBuilt 1987 · S/N 0050FF N530FMGooseneck Inc · Heber City, UTBuilt 2015 · S/N 0253FF N530JLLas Vegas Metropolitan Police Department · Las Vegas, NVBuilt 2015 · S/N 0251FF N530JRApex Heli-Support LLC · Phoenix, AZS/N 0711FF N530RLGulf Helicopters LLC · Santa Fe, TXS/N 0602FF N530STJ&J Holdings And Investments LLC · Phoenix, AZBuilt 2000 · S/N 0142FF N530TGSummit Helicopter Inc · Pacoima, CAS/N 0174FF N530THHeliservice LLC · Wilmington, DEBuilt 1996 · S/N 0600FF N530TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2009 · S/N 0172FF N530VHSvp LLC · Missoula, MTBuilt 2012 · S/N 0187FF N530WHWinco Inc · Aurora, ORBuilt 2008 · S/N 0151FF N530XOxford Police Department · Oxford, ALBuilt 1994 · S/N 0112FF N530XXFerguson And Sons Construction LLC · Emmett, IDBuilt 2000 · S/N 0710FF N531RGS & S Aviation Services Inc · La Crescenta, CABuilt 1990 · S/N 0080FF N531VBCity Of Virginia Beach · Virginia Beach, VABuilt 2019 · S/N 0321FF N531WCWilson Construction Co · Canby, ORBuilt 2009 · S/N 0161FF N531WHWinco Inc · Aurora, ORBuilt 1985 · S/N 0011F N532LGS & S Aviation Services Inc · La Crescenta, CABuilt 1992 · S/N 0092FF N532WCWilson Construction Co · Canby, ORBuilt 2007 · S/N 0148FF N532WHWinco Inc · Aurora, ORBuilt 1991 · S/N 0719FF N534WHTwin Equipment LLC · Red Bluff, CABuilt 2009 · S/N 0164FF N535HASummit Helicopters Inc · Salem, VABuilt 1977 · S/N 5035 N535WHTwin Equipment LLC · Red Bluff, CABuilt 1989 · S/N 0605FF N53702Helicopter Applicators Inc · Gettysburg, PABuilt 1983 · S/N 51249 N537WHWinco Inc · Aurora, ORBuilt 2008 · S/N 0155FF N538TDEl Destino LLC · Monticello, FLBuilt 1996 · S/N 52169 N539AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52468 N53HPHigh Performance Aircraft LLC · El Cajon, CABuilt 2009 · S/N 0159FF N540HHBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 0186FF N5415XConnecticut Air And Space Center · Stratford, CTBuilt 1981 · S/N 760199 N543HAMagnum Aviation LLC · Goff, KSBuilt 1978 · S/N 5043 N545SAShier Aviation Corp · San Diego, CABuilt 1983 · S/N 51063 N547AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52471 N54BLDaumeries Baudouin · Pagosa Springs, COS/N 233 N54NYWisk Aero LLC · Mountain View, CABuilt 1983 · S/N 45770 N551CPCity Of Columbus · Columbus, OHBuilt 2006 · S/N 0716FF N552AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52478 N553AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52474 N553CPCity Of Columbus Division Of Police · Columbus, OHBuilt 2008 · S/N 0715FF N557CPCity Of Columbus · Columbus, OHBuilt 2011 · S/N 0717FF N558AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52470 N559AEAir Evac Ems Inc · O'Fallon, MOBuilt 2015 · S/N 52472 N55SLHelicopters Inc · Cahokia, ILBuilt 2007 · S/N 52347 N55VKBaronanza LLC · Wilmington, DEBuilt 2004 · S/N 1 N560PK&D Aviation LLC · Kingston, OKBuilt 1982 · S/N 51013 N563AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52475 N566AFRickards Aviation Group LLC · Dagsboro, DEBuilt 1981 · S/N 45565 N56757Jbi South Leasing LLC · Pembroke, NHBuilt 1994 · S/N 52072 N567AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52477 N570KDK&D Aviation LLC · Kingston, OKBuilt 1994 · S/N 52079

Back to AD 85-25-07 R1