AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N5105ESayers James B · Edison, OHN5105JNickravesh Niknam John · Saratoga, CAN5105QBailey Glenn E · Oldenburg, INN5105RSale Reported · Colville, WASale reported, pending cancellationN5105SSyphers Harold A · Aguila, AZN5105VOrr Samuel L · Cleveland, GAN5105WVroman Kiersten · Fort Edward, NYN5105XManairco Inc · Wooster, OHN5105YMcduff Douglas M · Cook, MNN5106CQuest Aviation Inc · Lake City, FLN5106DOut Of The Blue Skydiving LLC · Parker, CON5106HMartinez Patrick F · Palmer, AKN5106LArnold John D · Reno, NVN5106RBenson Robert W · Wichita Falls, TXN51070Rabbit Hill Industries Inc · Bedford, NYN5107CDalrymple Michael J · San Luis Obispo, CAN5107DHardman Lorin D · Wasilla, AKN5107EMixon Dennis E · Topsham, MEN5107HFlyit LLC · Camas, WAN5107LSmith Jeremy · Houston, TXN5107MBahus Jason · La Porte, INN5107NChristiansen Aviation LLC · Wilmington, DEN5107SJdc Aviation LLC · Upland, CAN5107TIron Horse Leasing LLC · Platteville, WIN5107VEckert Robert E · Edgewood, TXN5107WRugger Investment Group LLC · Sheridan, WYN5107ZBasic Daniel J · Mulberry, FLN5108DTeam Gateway LLC · Lewes, DEN5108JHembree Ricky · Rockwall, TXN5108NBerry Lisa A · Yuba City, CAN5108QPardue William C Jr · Leesville, LAN5108TMarks Daniel A · Portersville, PAN5108VDavis John K · Texarkana, ARN5108WJennings Todd R · Hawthorne, FLN5109DCaine Jennifer M · Rigby, IDN5109GSnamiska Kyle · Cypress, TXN5109QRmcb LLC · Kalispell, MTN5109SBucek James A · Baytown, TXN510AASky West Aviation Inc Trustee · Albuquerque, NMN510ARBrudigam Norman · Lafayette, CAN510BLWingsleasing LLC · Wichita, KSN510CDMcgraw Jon W · Sitka, AKN510CHTj Air Holdings Inc Trustee · Wilmington, DEN510DYoungs Water Conditioning Of Logansport LLC · Logansport, INN510DDSchardt Donovan D · Juniata, NEN510DFDunkle Steven P · Newnan, GAN510DSTrussler Leslie Henley · Manchester, TNN510ECState Of Tennessee Department Of Transportation · Nashville, TNN510FMckeen Charles Dale · Howard Lake, MNN510FAEndeavour Flight Training Inc · Opa Locka, FL
Back to AD 2007-04-19 R1