AD 68-07-08
Registered aircraft · 196
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:68-07-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:68-07-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:68-07-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:68-07-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.
N411CBOsky Deuce LLC · Saguache, CON4159CPerkins Kenneth D II · Eagle River, AKN4550RCarpenter Kevin C · Dallas, TXN4602TPyles Nathan C · Ypsilanti, MIN4604TWeitemier Stanley G · Wadena, MNN4607TPbk Aviation LLC · Jefferson, GAN4609TLamoureux Nicholas J · Moab, UTN4612TWeaver Matthew B · Kasilof, AKN4613TSullivan William R II · Sierra Vista, AZN4614TOdonnell Daniel V · Dover, DEN4617THuttunen Leslie M · Wasilla, AKN4618TWoolston Evan K · Belle Fourche, SDN4619THurlbert 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, PAFirst renewal noticeN4711TDelaney 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, AKN4744TKolp Mark H · Andrews, TXFirst renewal noticeN4745TLee Andrew L · Anchorage, AKN4747TRegistered aircraftN474WH&H Restoration LLC · Wasilla, AKN51127Elsner Henry · Greensboro, NCN51207Crosswind Ventures LLC · Carson City, NVN51229Rossettie Thomas P · Manchester, MIN51273Stieler Paul O · Albert Lea, MNN51407Soper Steven Trustee · Rathdrum, IDN51419Registration Pending · Port Orchard, WARegistration pendingN51425Black James P · Kooskia, IDN51430Burke Warren V · Lakewood, CON51436Boardman Danvers · Talkeetna, AKFirst renewal noticeN51445Lanier John L · Madison, AL
Back to AD 68-07-08