AD 84-01-02 R1
Registered aircraft · 498
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:84-01-02-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:84-01-02-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:84-01-02-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:84-01-02-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.
N5288XCollier Mosquito Control District · Naples, FLN52RDHelicopter Services West LLC · Benicia, CAN530HBKansas Farm & Ranch Inc · Seneca, KSN5313YSeley Corp · Ketchikan, AKN531WHWinco Inc · Aurora, ORN533DRLt Aviation LLC · Lexington, KYN535XOxford Police Department · Oxford, ALN537STJ&J Holdings And Investments LLC · Phoenix, AZN53846Aerial Solutions Inc · Tabor City, NCN538STJ&J Holdings And Investments LLC · Phoenix, AZN53HCDrive A Tank Inc · Kasota, MNN541Chaparral Air Group · Grapevine, TXN54528Jobe Jeff · Redmond, WAN546Moore Lewis D Jr · Bear Creek, NCN54PDCameron Kenneth D · Montgomery, TXN550JMNational Aggregates Inc · Malvern, OHN555BHAgricultural Air Services LLC · Jupiter, FLN556ACAc Odyssey LLC · Bellevue, WAN556MHAa Leasing Lp · Kilauea, HIN557TSLone Oak Aviation LLC · Stayton, ORN569FCFerguson And Sons Constructions LLC · Emmett, IDN56TWMckee John · Central Point, ORN571HHHlh Leasing LLC · Wilmington, DEN572SABank Of Utah Trustee · Salt Lake City, UTN58191Temsco Helicopters Inc · Ketchikan, AKN58243Aa Leasing Lp · Kilauea, HIN58251Windward Aviation Inc · Puunene, HIN58252Windward Aviation Inc · Puunene, HIN58337Temsco Helicopters Inc · Ketchikan, AKN58341N953xt LLC · Henderson, NVN58350Siller Helicopters Inc · Yuba City, CAN58415Temsco Helicopters Inc · Ketchikan, AKN58428Teryjon Aviation Inc · Bluefield, VAN58431Dodson Larry · Lone Oak, TXN58479Usda Aphis Ws Atoc · Cedar City, UTN593CK & S Helicopters Inc · Kailua Kona, HIN594DBDeland Air And Sea Brokerage Inc · Deland, FLN59CPAtomic Eft LLC · Scottsdale, AZN59SDInternational Air Services Inc Trustee · Carson City, NVN5FCSara Helicopters Inc · Wilmington, DEN600FHFatv LLC · Henderson, NVN610ESAmarillo Skies LLC · Angleton, TXN622PBPope James · Lewiston, IDN6246WStarfire Aviation LLC · Renton, WAN6252FRoxbury John A Jr · Princeton, MNN6295PCaribe Helicopters Inc · Coral Gables, FLN62UCCbft LLC · Mobile, ALN630NBank Of Utah Trustee · Salt Lake City, UTN633JHJack Harter Helicopters Inc · Lihue, HIN64RSRainbow Air Inc · Niagara Falls, NY
Back to AD 84-01-02 R1