AD 65-18-01
Registered aircraft · 63
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:65-18-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:65-18-01')
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:65-18-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:65-18-01') 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.
N12008Dvoracek Dana J · Charlevoix, MIN12009Jordan Ronald W · Stoutsville, OHN12011Marsh John Edward · Washington, DCN12014Thompson Robert J · Kaktovik, AKN12015Thurmond Paul J · Huntley, MTN12016Swain Michael J · Jacksonville, FLN12017Nuckles Charles Austin Jr · Suffolk, VAN12018Theriot Harris J Jr · Thibodaux, LAN12026Bernhardt Michael J · North Branch, MNN12027Rugland Roger E · Anoka, MNN12029Dippold Lois M · Perry, MIN12031Burnett Brandon Ryan · White Lake, MIN12032Riebe Robert D · Caldwell, IDN4089CBork Joseph L · Mosier, ORN4130CSwift Stephen V · Redding, CAN4140CAllen Ira R · Tallahassee, FLN4159CPerkins Kenneth D II · Eagle River, AKN4170CDemientieff Oscar · Anchorage, AKN4180CMckenney Bret · Billings, MTN4602TPyles Nathan C · Ypsilanti, MIN4604TWeitemier Stanley G · Wadena, MNN4607TPbk Aviation LLC · Jefferson, GAN4609TLamoureux Nicholas J · Moab, UTN4613TSullivan William R II · Sierra Vista, AZN4614TOdonnell Daniel V · Dover, DEN4617THuttunen Leslie M · Wasilla, AKN4619THurlbert Michael L · Wasilla, AKN4621TIrby Donald K · Cushing, TXN4623TCorey Glenn M · Wilsonville, ORN4624TEisel Adam A · Copenhagen, NYN4700TGoulet Jason · Angle Inlet, MNN4701TOsborne Richard N · Roscoe, TXN4703TByrnes Patrick R · Nampa, IDN4706TMaule Susan · Media, PAN4711TDelaney Spencer R · Fairfield, CAN4712TKilcourse Jeffrey Kenneth · Tequesta, FLN4713TMichigan Air Service Corp · Troy, MIN4714TJed Homes Inc · Lisbon, CTN4717TStartin Tyler D · Colfax, WAN4718TArcand David R · Forest Lake, MNN4727TRimediare Aircraft LLC · Tucson, AZN4729TNevergall Michael · Brighton, CON4730TEgge Danny C · Pelican Rapids, MNN4733TMacneil David · Clarkston, WAN4734TSmiley Mark R · Baden, PAN4736TLb Aero Services Inc · Poplar Grove, ILN4737TFly Buys Inn · Wilmington, DEN4739TJohn Ross St · Anchorage, AKN4740TGerdes Douglas R · Macon, GAN4743TWeaver Matthew B · Kasilof, AK
Back to AD 65-18-01