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.
N5902QYow Franklin S · Grand Blanc, MIN5903QPressley Brent DBA · Morristown, TNN5904QLorincz Dennis K · Wadsworth, OHN5905QWainwright Mitchell J · Saint Charles, MON5907ERiver City Flying Club Inc · Valley Center, KSN59086Maxwell James B · Lewiston, IDN5908QT&T Aviation LLC · Clarksville, TNN5909EOwens Flight Training LLC · Lafayette, LAN590SProspect Ridge Aviaton Inc · Morganton, NCN5911QFuller Christopher · Ottsville, PAN5912QWilson Paul M · Bonifay, FLN5915QHaslem Patrick S · Dimondale, MIN5916JUnited States Air Force - Owner · Eglin Afb, FLN5916QSeidel Daniel F · Los Altos Hills, CAN5918QNorheim Bjoern T · Phoenix, AZN5919QBig Sky Adventures LLC · Nicholasville, KYN591PHKingdom Air Corps · Sutton, AKN5920QKellogg Annabelle S · Cumming, GAN5921EPeterson Dennis L · Daleville, ALN5922EAerial Scouting Solutions LLC · Sioux Center, IAN5924QWright Andrew · Sacramento, CAN5928EGace Flying Club Inc · Ronkonkoma, NYN5928QSchmidt Tyren A · Albertville, MNN592RJWood Roger E · Waxhaw, NCN5933QDonaldson Lucas P · Owyhee, NVN5936QEllis Robert L · Columbus, OHN5937QPospicil John A · Huntsville, ALN5938QNeely Eric R · Seagoville, TXN5939EWhite Sound International Ltd · New Smyrna Beach, FLN593STN593st LLC · Bangor, MEN5942QBravo J Bravo Aviation LLC · Louisville, KYN5943EPlane Zane LLC · Stuart, FLN5943QFreeborn Andrew B · North Las Vegas, NVN5947NGmm Records · Big Pine Key, FLN5947QMorales Nelson · Hendersonville, NCN5948ETlt Legacy LLC · Fort Worth, TXN5948QKrull Lynn · Thompson, IAN594AMMaarouf Mike · Taylor Lk Vlg, TXN5951ELlano Alfonso · Tucson, AZN5953QRoberts Stephen C · San Marcos, TXN5954QDominique Jon Andrew · Lenoir, NCN5955EClover Park Technical College · Tacoma, WAN5956EWalsh James · Hayden, IDN5956QHunt Brian A · Alexandria, VAN5958QInnovative Orthopedics Inc · Arcadia, OKN595ACBordlemay John J · Lewisberry, PAN595KHarvey Air LLC · Doylestown, PAN595LTN595lt LLC · Edwards, CON595VNess David A · Minneapolis, MNN5960QPlett Leo V · Liberal, KS
Back to AD 80-25-07 R1