AD 72-07-10
Registered aircraft · 617
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:72-07-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-07-10')
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:72-07-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-07-10') 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.
N321DDoyle Charles J · Sequim, WAN32MLAnderson Seth A · San Marcos, TXN342ASlater Trevor M · San Mateo, CAN34WLSeaquist Gregory C · Oneida, WIN3LCStimson Andrew J · Battle Ground, WAN3LYBurkey Jeffery C · Stuart, FLN400NCOkpysh Christina D · Santa Barbara, CAN4023LCenteno Ramon A · Oak Creek, WIN41HBWalsh Bowen S · North Augusta, SCN41RCCurtis Craig C · Dacula, GAN470DWWhitesell Paul Trustee · Plano, TXN4853LSipos Henry A · Huntington Beach, CAN495WDaniel Zachary T · Mckinney, TXN513BASong Su H · Duluth, GAN525RTLester Wm Curtiss · Martinsville, VAN529JHCoconut Racing Group LLC · North Miami, FLN52TN52t LLC · Pleasant Prairie, WIN540GTMatthews Guy · Geneseo, NYN553HBrantley Hugh L · Hazlehurst, GAN5601LManheimer Robert M · Marysville, WAN5606LJones Andrew S · Greensboro, GAN5612LHolden Jason K · Conroe, TXN5614LFiler Jacob Adam · Clarksville, TNN5615LAnthonson Ronald G · Cortland, NYN5619LEncarnacion Ramon A · Miramar, FLN5620LRichardson Carl · Jonesboro, GAN5627LFrattarelli Marco · Carrollton, TXN5631LKing Michael Wayne · Centreville, MDN5632LLas Vegas Aerial Services LLC · Las Vegas, NVN5634LOlson Mitch A · Silver Springs, NVN5635LCentury Air Inc · Fairfield, NJN5636LCrosby Thomas G · Saint Charles, MON5643LChaney Timothy W · Peoria, AZN5644LMartinez Pedro M · BreeNon-citizen corporation, flight hours not reportedN5645LT2tc LLC · Enka, NCN5646LHutcheson Bruce D · Anthem, AZN5653LUlpiano Amy · Carolina, PRN5657LSkyray LLC · Sugar Land, TXN5658LBores Scott J · Huron, OHN5663LChino Aviation Inc · Chino, CAN5669LGallien Justin A · Livermore, CAN5670LCranford Julian Edward Jr · Lexington, NCFirst renewal noticeN5671LJudge Russell M · Newton, NJN5677LDuncan Lincoln · Dix, ILN5680LStackpole Thomas M · Temecula, CAN5682LLahlum Steven R · Warroad, MNN5685LFritz Frank M · Milwaukee, WIN5686LBresson Kyle M · Roxbury, CTN5687LDedominici Kenneth · Vero Beach, FLN5688LDolan John C · Sequim, WA
Back to AD 72-07-10