AD 84-10-01 R1
Registered aircraft · 20,481
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-10-01-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-10-01-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-10-01-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-10-01-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.
N56TVKoerper Md LLC · Las Cruces, NMN56WKarpik Joseph P · Floodwood, MNFirst renewal noticeN5700MPangaea Air Service Inc · Aspen, CON5704BTveitnes Svein T · Whitewright, TXN5706JTaylor Larry D · Meridian, IDN5706RGraham Charles Arbe · Dexter, MIN570DBAtlas Aviation Tampa Inc · Tampa, FLN570DSSmith David A · Evergreen, CON570JSRust James P · Seymour, INN5710BNampa Aviation Holdings LLC · Boise, IDN5711BVtoss Holdings LLC · Anchorage, AKN5712JFree Air LLC · Helena, MTN5715RBingham David · Marked Tree, ARN5716BHare Alison S P Trustee · Grass Valley, CAN5716JTaos Sky Flight School LLC · El Prado, NMN57180Homo Holdings LLC · Kalispell, MTN5718BKlingler Lawrence R · Wolfeboro, NHN5719BAdventures In The Sky Aviation LLC · Fresno, CAN571CRegistered aircraftN571MCThompson Gary R · Discovery Bay, CAN571TCPardue Troy W · Downsville, LAN5722BVelasquez Benjamin · Anchorage, AKN5723JMcdonald Larry H · Little River, SCN5726BBend Aircraft Rentals LLC · Bend, ORN5728BHawkins Charles A Sr · Chillicothe, OHN572DHSportsmans Recon LLC · Hartwell, GAN572GSickles James D · Caledonia, NYN5731JPaulick Adam J · Deerfield, WIN5733BRobertson Nate Allen · Aiken, SCN5737JSkolnik Adam R · Clermont, FLN573JFHuddleston Edward L · Oaktown, INN573KKTextron Aviation Inc · Wichita, KSN5740BPash Olin M · Harlan, IAN5740JStonestreet Arlie D Trustee · Pratt, KSN5741BCansino Ross G · George West, TXN5743JMidwest Aerial Photography · Galloway, OHN5744BMcgrew Robert P III · Red Bluff, CAN5745JJohnson Charles R · Aurora, OHN5746JPassage Way Farms · Lyon, MSN5747BFarris Steve R · Fresno, CAN5748JWallner Patrick J · Redding, CAN574CACivil Air Patrol · Maxwell Afb, ALN574STState Of Alaska · Anchorage, AKN574WBDeal Timothy E · Anchorage, AKN5751BMacon Michael D · Sisters, ORN5751JB & H Drilg · Winnsboro, LAN5752BWallace Thad Joseph · Mount Shasta, CAN5755GDestination Alaska Air Service LLC · Homer, AKN5755JBagge John A · Independence, IAN5756BWages Brent · Rupert, ID
Back to AD 84-10-01 R1