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.
N53507Flight School Of Gwinnett · Lawrenceville, GAN5350KCenterline Aviation LLC · Oklahoma City, OKN5350MNewsom Bearden And Cobb Inc DBA · Lubbock, TXN5350PChristiansen Aviation LLC · Wilmington, DEN5350SSilver Tree LLC · Southern Pines, NCN5351HHayes Jeffery M · Yatesville, GAN5351LHillsboro Aero Academy LLC · Hillsboro, ORN5351PPointair Aviation Inc · Port Jeff Sta, NYN5351QBarrett Dannie P · Halfway, ORN5352KPea-Wayman Flight LLC · Daytona Beach, FLN5353HDe Nunzio Arnold J · Ballard, CAN5353KCentury Air Inc · Fairfield, NJN53540Orlando Aero Club Inc · Orlando, FLN53541Ps N53541 LLC · Green Bay, WIN5354DGonzalez Alejandro B · El Paso, TXN5354RCape May Aviation LLC · Cape May, NJN5354SArcturus Bootes LLC · Wilmington, DEN5355PPittsburgh Pilot Training LLC · Bethel Park, PAN5355QGorge Winds Aviation Inc · Fairview, ORN5356DDethlefs Robert L · Clackamas, ORN53571George Michael F · Ferndale, WAN5357EHoffman Dennis M · Winchester, VAN5357HRichmor Aviation Inc · Hudson, NYN5357JArizona Bravo Lima LLC · Phoenix, AZN5357PSunrise Aviation Inc · Ormond Beach, FLN53588Davis Charles · Sanford, FLN5358DXin Han Aviation LLC · Atwater, CAN5358TCarr Jon C · Shell Knob, MON5358UMadson Chris · King City, CAN5359APalo Duro Aircraft Services Lc · Mckinney, TXN5359SRegistered aircraftN535MESky West Aviation Inc Trustee · Albuquerque, NMN53600Kdrd Holdings LLC · Texas City, TXN53603Wings Over Texas Holdings LLC · Denton, TXN5360JFly Montana LLC · Miles City, MTN53611Aero Mobil Inc · Wilmington, DEN5361KLong Island Soaring Association · Shirley, NYN53622Mc Air LLC · Miami Beach, FLN5362AFerguson Lynn D · Alpine, WYN5362HMccue Tedd R · Eveleth, MNN5362TLipscomb Rik · Wichita Falls, TXN53630Arlington Flight Services Inc · Arlington, WAN53632Siple Aviation LLC · Kalispell, MTN5363KMission Aviation Training Academy · Arlington, WAN5364KAir S&T LLC · San Juan Capo, CAFirst renewal noticeN5364POwens Flight Training LLC · Lafayette, LAN5365GKlaw-N5365g LLC · Lawton, OKN5365QWelborn Mark · Boonville, NCN53663Iron Shield Aviation LLC · Fort Pierce, FLN5366JSlipstream Aviation LLC · Calera, AL
Back to AD 80-25-07 R1