Skip to content

Registered aircraft · 146

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:2018-17-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-01') 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:2018-17-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-01')
  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:2018-17-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-17-01')
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.

N101HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39123 N1026YKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 2005 · S/N 36391 N103HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39125 N1079UTurbines Ltd · West Point, NEBuilt 1980 · S/N 31122 N110LAConsolidated Fire Protection · Pacoima, CABuilt 2005 · S/N 36392 N11PPUS Dept Of The Interior · Boise, IDBuilt 2003 · S/N 36316 N120LACounty Of Los Angeles Fire Dept · Pacoima, CABuilt 2007 · S/N 36455 N133LAConsolidated Fire Protection · Pacoima, CAS/N 39136 N139TCBell Textron Inc · Fort Worth, TXS/N 39160 N141FAOrange County Fire Authority · Irvine, CABuilt 2008 · S/N 36484 N143PHWestern USA Solutions Inc · Kodiak, AKS/N 33134 N144ATBell Textron Inc · Fort Worth, TXS/N 39144 N145BHBell Textron Inc · Fort Worth, TXS/N 39145 N148BHBell Textron Inc · Fort Worth, TXS/N 37014 N14LACounty Of Los Angeles · Pacoima, CABuilt 2005 · S/N 36393 N155DBSalmon River Helicopters Inc · Riggins, IDBuilt 1997 · S/N 36156 N156BHBell Textron Inc · Fort Worth, TXS/N 39156 N156MHMansfield Heliflight Inc · Milton, VTS/N 33184 N157BHBell Textron Inc · Fort Worth, TXS/N 39157 N16920Temsco Helicopters Inc · Ketchikan, AKBuilt 1977 · S/N 30865 N16930Temsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 30920 N17LASan Juan Aviation LLC · Wilmington, DEBuilt 1992 · S/N 36044 N18LACounty Of Los Angeles Fire Department · Pacoima, CABuilt 1992 · S/N 36043 N193ATBell Textron Inc · Fort Worth, TXS/N 39148 N193BMBell Textron Inc · Fort Worth, TXS/N 39149 N21221Bank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 30773 N21225Bank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 31183 N21240Bank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 30783 N212AHAspen Helicopters Inc · Oxnard, CABuilt 1979 · S/N 30959 N212BTRedding Air Service Inc · Redding, CABuilt 1978 · S/N 30870 N212DFState Of Nevada · Reno, NVBuilt 1975 · S/N 30676 N212HBBritt Christopher Charles · Bryan, TXBuilt 1982 · S/N 31214 N212HLRogers Helicopters Inc · Fresno, CABuilt 1974 · S/N 30621 N212HPCorpat Inc · Missoula, MTBuilt 1979 · S/N 30951 N212NBA&P Helicopters Inc · Richvale, CAS/N 30599 N212THCougar Aviation LLC · Fresno, CABuilt 1980 · S/N 31109 N212TPNational Test Pilot School · Mojave, CABuilt 1971 · S/N 32003 N216APA&P Helicopters Inc · Richvale, CABuilt 1973 · S/N 30576 N217APCopter Lease LLC Trustee · Albuquerque, NMBuilt 1982 · S/N 31218 N21844Los Angeles Police Dept Air Support Division · Los Angeles, CABuilt 1999 · S/N 36229 N219MGAir Methods LLC · Greenwood Village, COBuilt 1998 · S/N 36218 N228SPSamaritans Purse · Boone, NCBuilt 2010 · S/N 36548 N22PPDepartment Of Interior · Boise, IDBuilt 1998 · S/N 36219 N232PJHelibro LLC · Red Bluff, CABuilt 1977 · S/N 30826 N233LCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 36269 N241FAOrange County Fire Authority · Irvine, CABuilt 2008 · S/N 36487 N249HVertol Systems Co Inc · Destin, FLBuilt 1993 · S/N 35061 N281SDCity Of San Diego · San Diego, CABuilt 1980 · S/N 31147 N282SDCity Of San Diego · San Diego, CABuilt 2008 · S/N 36466 N284SDCity Of San Diego Fire-Rescue Dept · San Diego, CABuilt 2024 · S/N 39132

Back to AD 2018-17-01