Registered aircraft · 207

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:2006-02-08-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:2006-02-08-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:2006-02-08-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:2006-02-08-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:2006-02-08-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:2006-02-08-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.

N29LBCity Of Long Beach · Long Beach, CABuilt 2003 · S/N 3760 N29LWTiny Bubbles Aviation Inc · Pacoima, CABuilt 2008 · S/N 4485 N2SDPinellas County Sheriff'S Office · Clearwater, FLBuilt 2006 · S/N 4099 N30EZHover Air LLC · Anchorage, AKBuilt 2011 · S/N 7285 N316ELMercy Air Helicopter Inc · Fort Lauderdale, FLS/N 3660 N320PANs Air Leasing LLC · Wilmington, DEBuilt 1988 · S/N 2143 N323AHBristow LLC · Lake Charles, LABuilt 2008 · S/N 4649 N326PDCity Of Anaheim · Fullerton, CAS/N 4555 N338SFErie County · Buffalo, NYBuilt 2001 · S/N 3480 N340PMAllred Leasing LLC · Missoula, MTBuilt 2004 · S/N 3778 N345HEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 1357 N349PAPathfinder Leasing LLC · Anchorage, AKBuilt 1995 · S/N 2868 N34CMNewcomer Christopher · Navasota, TXBuilt 2002 · S/N 3528 N350DHGuardian Flight Holdings Inc · Fairbanks, AKBuilt 2002 · S/N 3567 N350GYAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 2003 · S/N 3747 N350LPAirman Helicopter Inc · Fort Lauderdale, FLBuilt 1987 · S/N 2041 N350MPCity Of Memphis Police Department · Memphis, TNBuilt 2004 · S/N 3783 N350RAirwest Helicopters Inc · Redlands, CABuilt 2000 · S/N 9015 N350RFZirkle Aviation LLC · Selah, WABuilt 2008 · S/N 4608 N350XDInternational Air Services Inc Trustee · Carson City, NVBuilt 2009 · S/N 4805 N351FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4704 N351HDT Scott Dunn Construction Inc · Phoenix, ORBuilt 2001 · S/N 3508 N351HNDiscovery Helicopters LLC · Las Vegas, NVBuilt 1996 · S/N 2957 N352PAPathfinder Leasing LLC · Anchorage, AKBuilt 2000 · S/N 3378 N352PDSuffolk County Police Department · Yaphank, NYBuilt 2009 · S/N 4741 N352RNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3664 N352VHElt Holdings LLC · Cottonwood, AZBuilt 1985 · S/N 1838 N353JSCedar Heights Aircraft LLC · Rhinebeck, NYBuilt 2005 · S/N 3931 N353PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3722 N354HDCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1991 · S/N 2479 N354PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3690 N355GLGarmin At Inc · Salem, ORBuilt 1996 · S/N 2952 N355RSThompson Flying Service LLC · Charleston, MOBuilt 2008 · S/N 4586 N357PAPathfinder Leasing LLC · Anchorage, AKBuilt 2003 · S/N 3675 N358TVTiny Bubbles Aviation Inc · Pacoima, CABuilt 2004 · S/N 3788 N35YYMike Rinker Aircraft LLC · Union City, TNBuilt 2009 · S/N 4673 N375AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20227 N375MBMh22 LLC · Minotola, NJBuilt 2007 · S/N 4337 N376AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20239 N382AKAlpha Aviation LLC · Anchorage, AKBuilt 2002 · S/N 3591 N384AKAlpha Aviation LLC · Anchorage, AKBuilt 1998 · S/N 3092 N387AK387ak LLC · Anchorage, AKS/N 3730 N390NSNorthstar Trekking LLC · Juneau, AKBuilt 1992 · S/N 2615 N392NSNorthstar Trekking LLC · Juneau, AKBuilt 2006 · S/N 4166 N393NSNorth Star Trekking LLC · Juneau, AKBuilt 2009 · S/N 4762 N401MFDare County · Manteo, NCBuilt 2015 · S/N 20024 N405AMAris Aviation Group LLC · Henderson, NVBuilt 1995 · S/N 2833 N405TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4476 N4061GBristow LLC · Lake Charles, LABuilt 1997 · S/N 3051 N4074EAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1996 · S/N 2950

Back to AD 2006-02-08 R1