AD 80-25-02 R2
Registered aircraft · 6,349
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-02-R2')
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-02-R2')
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-02-R2') 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-02-R2') 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.
N4466NLyons Larry A · Stockton, ILN4468QStephney Zaccheus K · Douglasville, GAN4470ETurner John C R · Broken Arrow, OKN4473YJackson Robert S · Gallatin, TNN4476EN4476e LLC · Saint Charles, MON447CTHowell Aviation LLC · Orlando, FLN4480MBush Pilot Inc · Soldotna, AKN4480VOrtiz Albert Mike · Redondo Beach, CAN4481EChambers David N · Cullman, ALN4482MPapon Bruce G · Hardtner, KSN4483MLorring David W · Fairbanks, AKN4485MSuper Cruiser LLC · Fort Wayne, INN4486MRnc Air Service LLC · Bedford, WYN4487MBoyer James A · Lancaster, OHN44AJMyers Nathan · Clarksburg, CAN44BAKnop Horacio M · Miami, FLN44EBray Nick R Trustee · China Spring, TXN44PXMartinez Victor J · Sylmar, CAN44WBEvans Jerry R · York, PAN44WERedman Harvey E · Lapeer, MIN44ZCMarker Michael M Jr · Los Lunas, NMN4500ZBielefeld James L · Kenai, AKN4502ZBoyer Bruce A · Toledo, OHN4509ZLawrence Bobby L · Willis, TXN450EZBassen Gerald R · St George, UTN4510ZLamphere Michael T · Whitehall, NYN4511ZKim Andrew · Upland, CAN4518ZHoecher Robert T · Anchorage, AKN4521ZWeichert Eric S · Janesville, MNN4526ZArmstrong Brandon M · Sierra Vista, AZN4529ZDaigle Michael R · Andover, NHN4530ZKirby Andrew P · Strattanville, PAN4532MObrien James P · Mullen, NEN4533ZDavis Taylor M · Doylestown, PAN4534ZKay Bennie L · Brigham City, UTN4540ZBerdine Kenneth B · Arnoldsburg, WVN45418Shartle Wesley P · Fredericksburg, PAN4542ZWaters Caleb M · Merritt Island, FLN4543ZSvec Adolph Ralph · Marengo, ILN4546ZPutter Jerry · Wellington, KSN454BCMir Ali · Saint Charles, MON4553ZRisbon Scott W · Crystal Spring, PAN4555ZScottini Ryan M · Kent, OHN455EZVan Every Jason E · Cleburne, TXN455GBBrs Leasing Inc · Wilmington, DEN4564ZJones Brad · Oak Hill, FLN4566ZPackett Roger L · Yachats, ORN4568FWings Over Texas Holdings LLC · Denton, TXN4568QMeacham Barry J · Glasgow, KYN4569KJts Aircraft LLC · Rock Hill, SC
Back to AD 80-25-02 R2