AD 84-10-01 R1
Registered aircraft · 20,483
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.
N3326FRegistered aircraftN3326RAnderson Patrick Alan · Ripley, WVN33277Niebuhr Bradley A · Morriston, FLN3327DWelborn Mark G · Boonville, NCFirst renewal noticeN3327RLyman Gregory A Trustee · Traverse City, MIN3327SDavis Blake A · Bellevue, TXN3328DAcme Aircraft Leasing Mt LLC · Kalispell, MTN3329DWarren Mark W · Arlington, WAN3329ERichards Erick F · Stamford, TXN3329FFerguson Ryan L · Fort Collins, CON3329UDirectional Holdings LLC · Missoula, MTN332JRAdair Lawrence L Jr · Fountain Run, KYN332SCSilver Creek Aviation Services · Fort Worth, TXN3330DState Of Alaska · Kodiak, AKN3330FEmk Trans LLC · The Dalles, ORN3330JDownwind Three Six LLC · Murfreesboro, TNN3330UWolford Alyson · Bonney Lake, WAN3330YTighe Joseph E · Kingsland, TXN3331DKramer Donald J · Buffalo, MNN3332UMing Greg A · Guymon, OKN3333YDeville Charles D · Clinton, LAN3334DRedford Daniel A · Wasilla, AKN3334YHarless Richard K · Battle Mountain, NVN3335DWilson Zane D · Fairbanks, AKN3335FSocorro Meraz · El Paso, TXN3335UFogle Kenneth J · Chagrin Falls, OHN3336SVancil Todd · Justin, TXN3336TBirch Point Ventures LLC · Virginia, MNN3337DSmooth Air LLC · Camas, WAN3337FAerolife Aviation LLC · Knox, INN3337SBeery Bruce M · Lakeland, FLN3338RMitchell And Son Aviation LLC · Greenwood, INN3339DSale Reported · Kalispell, MTSale reportedN333BCMcfadden John L · Cresson, TXN333DAFavor Michael D · Chico, CAN333FFBass Thomas M Trustee · Kalispell, MTN333FUIntricate Bay Operating LLC · Iliamna, AKN333GKCenturion210 LLC · Amherst, NHN333HRWilson Alan E Trustee · Erie, CON333JWPhillips John Patrick · Cumming, GAN333LB333lb LLC · Fort Worth, TXN333LHKoelbl Aviation LLC · Whitesboro, TXN333PLPilot Maker LLC · Hayward, CAN333PSDoran Jeffrey T · Westerville, OHN333QBAdams Chad D · Dayton, ORN333VWHelderman Laban W · Newton, NCN333YTRegistered aircraftN333ZVWalker Wilber D III · Beeville, TXN3340RFrieze Rex · Fair Play, MON3340SRegistration Pending · Wilmington, DERegistration pending
Back to AD 84-10-01 R1