Skip to content

Registered aircraft · 206

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:2012-22-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-22-06') 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:2012-22-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-22-06')
  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:2012-22-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-22-06')
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 N107BZCounty Of San Diego · El Cajon, CABuilt 1968 · S/N 30013 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 N120SHHelicopter Applicators Inc · Gettysburg, PABuilt 1972 · S/N 30119 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 N15HXHelicopter Express LLC · Chamblee, GABuilt 1972 · S/N 30117 N16920Temsco Helicopters Inc · Ketchikan, AKBuilt 1977 · S/N 30865 N16930Temsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 30920 N16HXHelicopter Express LLC · Chamblee, GABuilt 1979 · S/N 30293 N17HXHelicopter Express LLC · Chamblee, GABuilt 1975 · S/N 30217 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 N205ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1974 · S/N 30161 N205BDVentus Ff LLC · Boise, IDBuilt 1971 · S/N 30097 N205BTRedding Air Service Inc · Redding, CABuilt 1974 · S/N 30173 N205CESouthern California Edison Co · Rosemead, CABuilt 1980 · S/N 30301 N205DYIdaho Helicopters Inc · Boise, IDBuilt 1978 · S/N 30282 N205GFGeorgia Forestry Commission · Macon, GABuilt 1979 · S/N 30300 N205GHRotorcraft Support Inc · Fillmore, CABuilt 1968 · S/N 30014 N205HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1970 · S/N 30100 N205LMVentus Ff LLC · Boise, IDBuilt 1974 · S/N 30213 N205RHSacramento Executive Helicopters Inc · Rancho Cordova, CABuilt 1973 · S/N 30127 N205TARoberts Aircraft LLC · Cheyenne, WYBuilt 1974 · S/N 30168 N205TKCoastal Helicopters LLC · La Verne, CABuilt 1973 · S/N 30131 N205VCVentura County Sheriffs Department · Camarillo, CABuilt 1969 · S/N 30066 N205WWBlades LLC · Arlington, WABuilt 1980 · S/N 30329 N211GHGuardian Helicopters Inc · Fillmore, CAS/N 30058 N211NWOlympic Jet Inc · Olympia, WABuilt 1975 · S/N 30177 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

Back to AD 2012-22-06