AD 2000-25-08
Registered aircraft · 306
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
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:2000-25-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-25-08')
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:2000-25-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-25-08') 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.
N350XDInternational Air Services Inc Trustee · Carson City, NVN351FSDiscovery Helicopters LLC · Las Vegas, NVN351FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN351HNDiscovery Helicopters LLC · Las Vegas, NVN351VSAlpine Air Alaska LLC · Girdwood, AKN352PDSuffolk County Police Department · Yaphank, NYN352VHElt Holdings LLC · Cottonwood, AZN353FSDiscovery Helicopters LLC · Boulder City, NVN353JSCedar Heights Aircraft LLC · Rhinebeck, NYN354AKAris Aviation Group LLC · Boulder City, NVN354HDCsc Delaware Trust Co Trustee · Wilmington, DEN354PDSuffolk County Police Department · Yaphank, NYN355AGHover-Views Unlimited Inc · Syosset, NYN355ARCsc Delaware Trust Co Trustee · Wilmington, DEN355ERElite Rotorcraft LLC · Mt Juliet, TNN355EXSolomon Mark Trustee · Wilmington, DEN355FFRichards William · Gardiner, NYN355HCAm Air Service LLC · Green Oaks, ILN355HRNext Level Aviation LLC · Pflugerville, TXN355JCMavana As LLC · Miami, FLN355NSNs Air Leasing LLC · Wilmington, DEN355RSThompson Flying Service LLC · Charleston, MON355SFHowe Aviation LLC · Surprise, AZN355THTimberland Helicopters Inc · Ashland, ORN358TVTiny Bubbles Aviation Inc · Pacoima, CAN3598DPope James Dean · Lewiston, IDN35JPEleven 11 Ventures LLC · Helena, MTN35YYMike Rinker Aircraft LLC · Union City, TNN3604TRotorcraft Support Inc · Fillmore, CAN360CHCoastal Helicopters Inc · Juneau, AKN367AMAir Services International Leasing LLC · Fort Lauderdale, FLN36TVUS Helicopters Inc · Marshville, NCN375MBMh22 LLC · Minotola, NJN381AKAlpha Aviation LLC · Anchorage, AKN382AKAlpha Aviation LLC · Anchorage, AKN384AKAlpha Aviation LLC · Anchorage, AKN390NSNorthstar Trekking LLC · Juneau, AKN391NSNorthstar Trekking LLC · Juneau, AKN392NSNorthstar Trekking LLC · Juneau, AKN393NSNorth Star Trekking LLC · Juneau, AKN394NSNorthstar Trekking · Juneau, AKN4022DTemsco Helicopters Inc · Ketchikan, AKN4035WDepartment Of Homeland Security · Washington, DCN4048LU S Dept Of Homeland Security · Washington, DCN4055LU S Dept Of Homeland Security · Washington, DCN40584Bristow LLC · Lake Charles, LAN405AMAris Aviation Group LLC · Henderson, NVN405TXTexas Department Of Public Safety · Austin, TXN4061GBristow LLC · Lake Charles, LAN4068WU S Dept Of Homeland Security · Washington, DC
Back to AD 2000-25-08