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.
N7262ACf Aviation Trust LLC Trustee · Wilmington, DEN7262EStrough Jacob L · Twin Falls, IDN7262MRegistered aircraftN72647Awa Tupua LLC · Brambleton, VAN7264DGravity & Grace LLC · Mill Valley, CAN7264NSelect Equipment Inc · Kokomo, INN72658Tidewater Flying Club Inc · Newport News, VAN7265NSkylane Bicentennial LLC · Waynesboro, VAN7265SRiver City Flying Club Inc · Sacramento, CAN72667Rro Leasing LLC · Grand Forks, NDN72669Mid-Island Air Service Inc · Ronkonkoma, NYN7266MFerrarer Joseph H Trustee · Glendora, CAN7266NBeck Robert A · Cove, ORN7266SRush William A Trustee · Boulder Creek, CAFirst renewal noticeN7266YAvero Aviation LLC · Dover, DEN7266ZBearing Tree Land Surveying LLC · Oklahoma City, OKN72671Vfr Aircraft And Training LLC · Farmington, MOExpired dealer, pending cancellationN7267EHigh Range Aviation Inc · Gooding, IDN7267NSwalling John C · Anchorage, AKN7267TDmcc LLC · Lewes, DEN7267YVolatilis Aviation LLC · Collinsville, ILN7267ZHoffpauir Jeremy · Broussard, LAN72689Brown Nathan · Snellville, GAN7268EBoyer Steven L · Wooster, OHN7268FFarber Gerald · Las Cruces, NMN7268GSteel & Supply Co LLC · Pensacola, FLN7268KFelts Field Flying Club · Spokane Valley, WAN72692Mccurdy Dwight B · Anderson, INN7269416 Sandals LLC · Tuscaloosa, ALN72697Cbt Aviation LLC · Bellingham, WAN7269BReece Vance · Winnsboro, TXN7269EFerguson Douglas M · Mount Vernon, ORN7269NAk Air Leasing LLC · Homer, AKN726HSSpmhrt 206 LLC · East Bernard, TXN726SAInternational Air Services Inc Trustee · Carson City, NVN7270HSundowners Inc · Fort Myers, FLN7270NRivera Daniel A · San Marcos, TXN7270QGrey-Gc LLC · Picayune, MSN7270YBlanton Kenneth A Jr · Cortland, NYN7271XAeolian LLC · Mcalester, OKFirst renewal noticeN7272EMonro Andrew C · Columbia X Rd, PAN7272RBst Equipment LLC · Spearfish, SDN7273EBlack Kennith M · Barboursville, WVN72749Sarkcap Global Inc · Carlsbad, CAN7274QPugliese Vincent · Woodbridge, VAN7274SWltf LLC · Frisco, TXN7275HBurch Preston M · Sykesville, MDN72762N72762 LLC · Sarasota, FLN7276HFlying Schnauzer LLC · Vestavia, ALN7276NDancer Aviation LLC · Delphos, OH
Back to AD 84-10-01 R1