AD 80-25-07 R1
Registered aircraft · 25,370
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N5032AHunter Aviation Inc · Benton, KYN5032FMusgrave John Robert · Morris, ILN5032GAmelia Reid Aviation LLC · San Jose, CAN5032J88 Charlies Inc · Palmyra, WIN5032URegistration Pending · Fort Huachuca, AZRegistration pendingN5032VLewis Timothy W · Thousand Palms, CAN50338Ware Michael · Bovina, TXN5033DSigurdson Richard J · Olivia, MNN5033FRohaly Richard L · Prineville, ORN5033KRichard Robin G · New Franken, WIN5033REastern Cincinnati Aviation Inc · Batavia, OHN5033VGarvis Darren G · Livermore, CAN5033WSapp Jedidiah T · Cordova, AKN5034GDyson James R · Hilltop Lakes, TXN5034HHernandez Dorothy V · Juneau, AKN5034KPiercy Ronald S · Moses Lake, WAN5034NLittle Gregory L · Carnegie, OKN5034VBibler Barry D · Spearfish, SDN5034WCurran Robert A · Waldorf, MDN50350Redline Shane Z · Amarillo, TXN50358Lockhart 50r Partners LLC · Austin, TXN5035GLasche James R Jr · Weatherford, TXN5035JNewton Justin T · Hurdland, MON5035NCp Aviation Inc · Santa Paula, CAN5035QWilfer Dennis M · Fairbanks, AKN50361Mcbride Daniel · Burleson, TXN5036GVagias Janet Rose · Niceville, FLN5036LAsplundh Eric · Bryn Athyn, PAN5036NWiedenmann Jerry Gene Jr · Drexel, MOFirst renewal noticeN5036RArctic Winds Inc · King Salmon, AKN50371Potter Michael J Jr · Fairbanks, AKN50376Hayes Brad M · Grove, OKN5037CHakel Bruce A · Fairbanks, AKN5037KD & K Aviation Inc · Milford, IAN5037NTriniair LLC · Warner Robins, GAN5037RJlinn Aviation Inc · Quinlan, TXN50380C P Aviation Inc · Santa Paula, CAN50384Anderson Donald · Simmesport, LAN50389Sale Reported · Kissimmee, FLSale reportedN5038AWild River Flying Club · Saint Croix Falls, WIN5038CHonea Richard S · Canton, GAN5038EHohman Brent A · Fulton, SDN5038GStarros John P · Los Angeles, CAFirst renewal noticeN5038KPiercy Ronald S · Moses Lake, WAN5038MMiller Aviation Group LLC · Coon Rapids, MNN5038UButler Industries Inc · Amarillo, TXN50395Registered aircraftN50397Wright Preston T · Deeth, NVN5039GPhronesis LLC · Tucson, AZN5039HBig Mountain Aviation Inc · Whitefish, MT
Back to AD 80-25-07 R1