Skip to content

AD 2011-18-51 R1

Registered aircraft · 785

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:2011-18-51-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:2011-18-51-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:2011-18-51-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:2011-18-51-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:2011-18-51-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:2011-18-51-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.

N40KCAir 1st Aviation Companies Inc · Glendale, AZBuilt 1974 · S/N 322 N411ZFGoggin Gerald M · Miami Beach, FLBuilt 1992 · S/N T101 N4152XAero Spray Inc · Kingfisher, OKBuilt 1974 · S/N 1928R N419SCZeplane LLC · Miami, FLBuilt 1980 · S/N 441-0149 N41LHSkyventure Arizona LLC · Eloy, AZBuilt 1981 · S/N SH 1977 N41NVNorth Valley Air Ltd · St Thomas, VIBuilt 1982 · S/N 4410268 N4206PHeritage Ag LLC · Lakeview, MIBuilt 2001 · S/N G10-166 N4208SOmega Air Service LLC · Fredericksburg, OHBuilt 2001 · S/N G10-167 N420LWCrazy Horse LLC · Princeton, WVS/N 11455 N4217XEarls Spray Service Inc · Breckenridge, MIBuilt 2001 · S/N G10-168 N421MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-634 N4223XAir Enterprises LLC · Dover, DEBuilt 1974 · S/N 1984R N422CABering Air Inc · Nome, AKBuilt 1982 · S/N 238 N422DFUsda Forest Service Fepp · Mcclellan, CABuilt 2001 · S/N 152817 N4239XMountain Air Spray Co · Craig, COBuilt 1974 · S/N 2012R N423DB2945l LLC · Terrell, TXS/N 1543 S.A.N423KAKmr Aviation Services Inc · Lynchburg, VABuilt 1993 · S/N 41023 N424CARyan Air Inc · Anchorage, AKBuilt 1981 · S/N 242 N424DFUsda Forest Service Fepp · Mcclellan, CABuilt 2001 · S/N 152820 N424MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-639 N425DFUsda Forest Service Fepp · Mcclellan, CABuilt 1999 · S/N 152825 N425DTSun Fast Inc · Mansfield, TXBuilt 1978 · S/N 11519 N425MACbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-640 N426CASpitaker Leasing LLC · Colorado Springs, COBuilt 1981 · S/N 168 N426DFUsda Forest Service Fepp · Mcclellan, CABuilt 1999 · S/N 152824 N426MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-645 N427DFUsda Forest Service Fepp · Mcclellan, CABuilt 2001 · S/N 153570 N428MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-646 N42AFWild Hare Enterprises LLC · Valparaiso, INBuilt 1980 · S/N 787 S.A.N42AXTheia Aviation LLC · Philadelphia, PABuilt 1996 · S/N 41084 N430MAGas/Wilson Inc · Traverse City, MIS/N AC-710B N430RRAce In The Sky LLC · San Antonio, TXBuilt 1974 · S/N AT030 N431DFUsda Forest Service Fepp · Mcclellan, CABuilt 2001 · S/N 149265 N431MTDucharme Paul Quinn · Lafayette, LAS/N LIV-517 N434CAHorizon Aire LLC · Colorado Springs, COBuilt 1981 · S/N 286 N435DFUsda Forest Service Fepp · Mcclellan, CABuilt 2001 · S/N 153573 N436DFUsda Forest Service - Fepp · Mcclellan, CABuilt 2001 · S/N 152337 N439DFUsda Forest Service Fepp · Mcclellan, CABuilt 2002 · S/N 149854 N439RARyan Air Inc · Anchorage, AKBuilt 1982 · S/N 287 N43GTDon Avion LLC · Cedar Park, TXBuilt 1978 · S/N 441-0043 N43SPSamaritans Purse · Boone, NCBuilt 1956 · S/N 140 N440ATT & M Aircraft LLC · Monticello, ILS/N G10-104 N440DFUsda Forest Service Fepp · Mcclellan, CABuilt 2001 · S/N 149873 N440EHSurdex Corp · Chesterfield, MOBuilt 1986 · S/N 441-0358 N441ABank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 441-0094 N441ABPistol Aviation LLC · Anaconda, MTBuilt 1981 · S/N 441-0284 N441AQM & M Aircraft LLC · Mankato, MNBuilt 1981 · S/N 4410203 N441BBMountain Sand Investment LLC · Wilmington, DEBuilt 1981 · S/N 441-0217 N441BFAmt Services Leasing Co Inc · Colorado Springs, COS/N 441-0145 N441BKBek Consulting LLC · Dickinson, NDBuilt 1981 · S/N 441-0215

Back to AD 2011-18-51 R1