AD 2012-11-08
Registered aircraft · 177
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:2012-11-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-08')
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:2012-11-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-08') 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.
N53GLWaco Classic Aircraft Corp DBA · Battle Creek, MIN53VCAbita Skies LLC · Robert, LAN543KThoensen Thomas R · Delta, CON5599BMccain David O · Ashville, ALN5603LKushnir Borys G · Tamuning, GUN5613LRed Rock Flyers LLC · Flagstaff, AZN5761GNelson Ken · Caledonia, WIN5761ZHannibal Aviation LLC · Stamford, CTN5762BAssociated Aircraft LLC · San Diego, CAN5762DNavar Thomas R · El Paso, TXN5762GBrown Patrick T Trustee · Osceola, WIN5886LCook Charles N · Lakeside, TXN5ZMDakota & Skyy LLC · Louisville, CON6016LAssociated Aircraft LLC · San Diego, CAN6022LIrving Donald J · Deland, FLN6036LCrestair Air LLC · Dover, DEN6053LHenson Randolph C · Spring, TXFirst renewal noticeN6054LTriple-R-Biplane Inc · Andover, NJN6075LChandler Air Service Inc · Chandler, AZN60GLMiko Pawel Marcin · Santee, CAN6185LKanaster Larry D Trustee · Tacoma, WAN6196LFiala Frederick P · Kingwood, TXN6197LRanger Airfield Foundation · Ranger, TXN6199LBoddy Derrick M · Aiken, SCN621GLOverwatch Tools Inc · Chesapeake, VAN6247LChandler Air Service Inc · Chandler, AZN6262LGreat Lakes Aircraft LLC · Palmer Lake, CON647KHoover Michael B · Ridgeland, WIN648KNichols Charles F Trustee · Baldwin Park, CAN703GLTimblin Joel R · Boyceville, WIN705KKelley Paul V Jr · Atlanta, GAFirst renewal noticeN707GLVoler Dans La Gloire LLC · Narberth, PAN707RMWilkes Jack M · Port Orchard, WAN711PTTaylor Stephen N · Punta Gorda, FLN727KRRogers Ronald J · Crystal Lake, ILN728GLMartin James D · Graford, TXN748LLdz Aviation Resources LLC · Sayville, NYN763GLUzyn Jerry J · Lafayette, INN765GLCroll H Robert III · Jacksonville, ORN76GLSullivan Vincent E · Centerville, IAN771VYGarcia Pedro · Hudson, OHN777PAce Aeromotive Inc · Miami, FLN780ZAGreat Lakes Belle LLC · Furlong, PAN789JFCoordinated Turn LLC · Fort Worth, TXN78JRFocus Air LLC · Wilmington, DEN791BKBoucher Robert Nc · The Plains, VAN799DBTreetop Flyer LLC · Crozet, VAN79GLJones Robert B · Fresno, CAN802GLGiles Forrest D · Springtown, TXN80AMGreat Lakes Aircraft LLC · Palmer Lake, CO
Back to AD 2012-11-08