AD 94-20-04 R2
Registered aircraft · 4,469
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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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.
N6057EPeterson Kenneth M · Henderson, NVN6058EBrandt Glen L · West Bend, WIN6059EWiseth Kurt C · Thief River Falls, MNN605KParlier Jacob B · Ashland, ILN6061EChase William B · West Des Moines, IAN6064EBeauboeuf Jeffrey M · Woodworth, LAN6064SYasechko James Edward · Bonaire, GAN6069SNelson Ronald E · Richmond, TXN6070EBas Part Sales LLC · Greeley, CON6070SEdward C Kole · Lake Geneva, WIN6071EBoltz Leonard E · Pearson, WIN6072EKnott Thomas · Clinton, MON6072SMiller Walter Timothy · Henderson, NVN6083ESwisher Michael S · Yukon, OKN6084EMargart Geoffrey W · Mount Shasta, CAN608BMacario T Michael · Townsend, DEN608QDoss Steven V · New Orleans, LAN608RBKnudsen Russell G · East Troy, WIN6092EHasan Reas · Raleigh, NCN6092SRobinson David John · Eads, TNN6093SFarmer Scott · Springtown, TXN6096EEuroaviation Inc Trustee · KematenN6097ERay Michael S · Charlotte, NCN60MLStephens Gary James · Austin, TXN60RMMartin Bennie D · Garden Ridge, TXN6100VDickson Bernard G · Chiloquin, ORN6106VMendoza Cesar · Anthony, NMN6108VMcpherson Richard R Jr · Butler, PAN610KGN610kg LLC · Tampa, FLN610QMarashi Farhad · Kingwood, TXN6111MBeech Club LLC · Lacrosse, INN6112VSlifkin Richard · Forest Hills, NYN6114VMarc Inc · Bolton, MSN6115VLloyd Timothy S · Yorba Linda, CAN6116VDoyle George H III · Anthony, NMN611MWolf Thomas James Trustee · Simi Valley, CAN611QLucky Star Farms LLC · Stuart, FLN6120VDraw Holdings LLC · Meridian, TXN6123XBuffalo Aviators LLC · Denver, CON612QWeisenseel Charles William · Bandon, ORN612TGadler Timothy L · Lake Oswego, ORN6130VKwalek Robert E · Shelton, CTN6135VSteinle Michael · Lake Village, INN6136VCcf Ventures Inc · Bangor, MEN6137VCarpmail Michael · Yakima, WAN613BPhotakis Gary B · Kirkland, WAN613DJacobsen Christopher C · Sandy, UTN613TPrice Melvyn J · Lancaster, SCN6147VBerry David A · Santa Cruz, CAN61487Vspeed LLC · Saint Paul, MN
Back to AD 94-20-04 R2