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.
N9959BHackamore Equipment LLC · Prairie City, SDN9959ETyler Matthew S · Lakeside, CAN9959HThibault William N · Newport Beach, CAN9959RRusyniak Anthony J · Syracuse, NYN9959XMiller Keith D · Pittsburgh, PAN9959YGrand Aviation LLC · Winter Park, COFirst renewal noticeN995SBRossi Randall A · Georgetown, TXN9960BSouthern Aircraft Leasing LLC · Montgomery, ALN9960RInternational Air Services Inc Trustee · Carson City, NVN9962ESynergy Financial Services Inc · Vancouver, WAN9962MFox Aircraft LLC · Bethel, AKN9962TWh72 LLC · Lincoln, NEN9963NWoodward Aviation LLC · Alpine, TXN9963YN9963y LLC · Provo, UTN9964CTakle Management LLC · Bethany, OKN9964EJansen Christopher · Stilwell, KSN9964HBuchanan Gary · Jay, FLFirst renewal noticeN9964KState Of Wisconsin Department Of Administration · Madison, WIN9964YGreenspun Mark H · Washington, DCN9965BTuma Tom · Cut Bank, MTN9965XNistler Matt J · Three Forks, MTN9966BKimbrell Heath · Quinlan, TXN9966NBeeson John Charles · Palmer, AKN9966TItalio River Adventures LLC · Yakutat, AKN9966XFickus Timothy R · North Pole, AKN9967CJoemac Business Services LLC · Casper, WYN9967NSawtooth Aviation LLC · Hovland, MNN9967RBravan Aviation · Fort Lauderdale, FLN9968CPaulin Gregory H · Flagstaff, AZN9968EReeder Joseph · Northfield, MNN9968JBoening Bros Dusting & Spraying Scv · Floresville, TXN9968NBuhannic Patrick A · Shepherdstown, WVN9968TMontague Robert · Kilmichael, MSN9968XEagley Ronald A · Anchorage, AKN9969CAttitude Indicators LLC · Allegan, MIN9969THatch Industries LLC · Snowflake, AZN996AKSierra Sky Aviation LLC · Kalispell, MTN9970ZHartland Aviation LLC · Hartland, MIN9971NCranford Billy J · Wasilla, AKN9971TGuardalabene Anthony E · Lake Havasu City, AZN9972NChandler E H Jr · Ozona, TXN9973FMayer Larry A · Billings, MTN9974ERajdl Alan · Deer River, MNN9974MAllmen David B · Valley Center, CAN9975TLancello Dylan E · Townsend, MTN9976BArend Robert E Jr DBA · Mark Center, OHN9976MBrush Wesley A · Sparks, NVN9977EDunlap Cameron · Campbell, NYN9977JBoening Bros Dusting & Spraying Inc · Floresville, TXN9977TGastineau Patrick S · Bothell, WA
Back to AD 84-10-01 R1