AD 68-07-07
Registered aircraft · 284
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-07')
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-07')
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-07') 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-07') 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.
N5508SKimmel Frank S III · Greenwood, MSN5517SRussell Charles B · Union City, TNN5523SDj Flight Service LLC · Little Falls, MNN5539SLm Air Patrol Service Inc · Wink, TXN5642JGreater Houston Soaring Association · Needville, TXN5647GDarter Lloyd R · Mountain Grove, MON5665JFarwest Aviation LLC · Billings, MTN5670JBank Of Utah Trustee · Salt Lake City, UTN5680JKnutson Wayne R · Thompson, NDN5685JAnderson Aerial Spraying Service · Canby, MNN5688JAnderson Aerial Spraying Service Inc · Canby, MNN5697JRidgway Rick J · Carlisle, INN5708GAir Dakota Flite · Hettinger, NDN58235Collins Wayne J · Lubbock, TXN5987GSchwend Brian · Forsyth, MTN6032RMatecumbe Flying Service Inc · Immokalee, FLN6048GWitthuhn Johnie B · Callaway, NEN6133GRosebud Aviation · Gregory, SDN6509GMehling Robert C · Hardin, MTN6606QAirtrust LLC - 1 - Series 1 Trustee · Sheridan, WYN6607BWhalen Mark P · Millington, MDN6623GMehling Robert C · Hardin, MTN6656GCommonwealth Of Massachusetts · Plymouth, MAN666JBCopenhaver Tracy K · Anthony, KSN685JMBallard Aviation · Waynesville, MON6872GVortex Aircrafts Inc · Port Saint Lucie, FLN70063Welch Thomas R DBA · Modesto, CAN70141Priewe Flying Service LLC · Como, MSN70231Low Level Aero LLC · Myakka City, FLN70288Dakota Aircare Inc · Wagner, SDN70326Triple E Farms LLC · Peculiar, MON70350Bigwings Ag Inc · Delavan, MNN70387Becker Flying Service Inc · Hartington, NEN70403Mccormick Eugene C DBA · Tyler, ALN72091Peralta Jose Ramon · Sinking Spring, PAFirst renewal noticeN72947Greer Glenn M · Eugene, ORN731ABA & C Ag Aviation Inc · Unadilla, GAN731BGKutschera Theodore C DBA · Callicoon, NYN731BMBenaiah Holdings Corp · Marion, KYN731CENoe Aviation LLC · Vinton, IAN731CQD & K Aviation Inc · Milford, IAN731ECFitchett Bradley S DBA · Ellsworth, KSN731EQUnited States Department Of Agriculture · Edinburg, TXN731ESSky Tech Inc · Dorchester, NEN731FMNew Frontier Aviation LLC · Fort Benton, MTN731FPLihs Ryan J · Sioux City, IAN731GDRegistration Pending · Walnut, ILRegistration pendingN731GPUpshaw John L Jr · Claude, TXN731GTDigger Dougs Crop Dusting Services Inc · Hollandale, WIN731KWVann Dudley C DBA · Greenville, NC
Back to AD 68-07-07