AD 2001-20-03
Registered aircraft · 224
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:2001-20-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-20-03')
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:2001-20-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-20-03') 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.
N238SRApple Realty Group Inc · Richmond, VAN23HXWillow Shade II Ltd · Englewood, CON24191Aircraft Guaranty Corp Trustee · Oklahoma City, OKN27MHelicopters Inc · Wilmington, DEN295SJPremier Rotors LLC · Saint Martinville, LAN29WWPremier Rotors LLC · Saint Martinville, LAN2WEWe Explore LLC · Redlands, CAN301JASale Reported · Oklahoma City, OKSale reportedN305MHMaritime Helicopters Inc · Homer, AKN311MHMaritime Helicopters Inc · Homer, AKN314AEAir Evac Ems Inc · O Fallon, MON314MHBlade Leasing LLC · Homer, AKN316MHMaritime Helicopters Inc · Homer, AKN317Magic Carpet Aviation LLC · San Antonio, TXN318RLOcean Air Helicopters Inc · Port Orford, ORN319AEAir Evac Ems Inc · O Fallon, MON325AEAir Evac Ems Inc · O Fallon, MON336AEAir Evac Ems Inc · O Fallon, MON338AEGm Leasing Co LLC · Broussard, LAN346BFState Of Washington · Olympia, WAFirst renewal noticeN34RMCrm Holdings LLC · Missoula, MTN352TCHillsborough County Board Of County Commissioners · Tampa, FLN355AEAir Evac Ems Inc · O Fallon, MON357SPLouisiana Department Of Public Safety · Baton Rouge, LAN35NRCentral States Helicopters Inc · Wood River, NEN361DT925dt LLC · Picayune, MSN378JCLongranger IV LLC · Missoula, MTN385RLSan Juan Aviation LLC · Wilmington, DEN386VCCounty Of Volusia · Deland, FLN38BZHelicopters Inc · Wilmington, DEN399AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN399MHBlade Leasing LLC · Homer, AKN3QYHelicopters Inc · Wilmington, DEN401FNNy On Air LLC · Kearny, NJN401FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeN402AEAir Evac Ems Inc · O Fallon, MON402FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeN404AEAir Evac Ems Inc · O Fallon, MON404MPIndustrial Helicopters LLC · Lafayette, LAN405LPGm Leasing Co LLC · Broussard, LAN406KKKehler Kelly · Saint Xavier, MTN406MPGm Leasing Co LLC · Broussard, LAN407AEAir Evac Ems Inc · O Fallon, MON408AEAir Evac Ems Inc · O Fallon, MON409AEAir Evac Ems Inc · O Fallon, MON410AEAir Evac Ems Inc · O Fallon, MON414AEAir Evac Ems Inc · O Fallon, MON415AEAir Evac Ems Inc · O Fallon, MON416AEAir Evac Ems Inc · O Fallon, MON417AEAir Evac Ems Inc · O Fallon, MO
Back to AD 2001-20-03