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.
N731LACmk Aerial Inc · Sutton, NEN731LFMcneill Dudley T · Happy, TXN731MKMccormick Eugene C DBA · Tyler, ALN731MRMerced County Mosquito Abatement District · Merced, CAN731PHTorkelson Charles A · San Antonio, TXN731PMAir Ag Inc · Tarboro, NCN731QCTim Whitfield Aviation · Fairfield, NCN731TBEastern Flying Service Inc · Middletown, DEN731TQSnider Scott E DBA · Turner, MTN731TSSantana Hector Rafael · Crystal River, FLN731UFPeniston Bob · Chillicothe, MON731VXGoff Bayou LLC · Shelby, MSN731VYCarr Scott A · Allen, NEN731WVKutschera Theodore C DBA · Callicoon, NYN731XGPeniston Charles R · Chillicothe, MON731XNPeniston Bob · Chillicothe, MON731YRAbernathy Larry D · Tipton, OKN76AGSkyview Applicators LLC · Hartington, NEN78417Mcelwain Russell D · Lancaster, KSN788BTPowers Elbie L · Roseboro, NCFirst renewal noticeN79080Snider Roger A · Harlem, MTN79260Sale Reported · Xxx, OKSale reported, pending cancellationN8000VCga Holdings LLC · Kalispell, MTN8007VJcr Ag LLC · Frederick, OKN8017VThrush Hills LLC · Volga, SDN8018VLight Flight Ltd · Lehighton, PAN8027VWalton Philip G DBA · Mankato, KSN8042VSale Reported · Watford City, NDSale reportedN8045VGreater Houston Soaring Assoc · Needville, TXN8046VSt Bernard Parish Police Jury · Chalmette, LAN8075GVaughns Flying Service Inc · Reese, MIN8079GBoney Grady · Rhine, GAN8080VTri Rotor Spray & Chemical · Ulysses, KSN8081VStorm Flying Service LLC · David City, NEN8086VSchmitt Rudy · Brookshire, TXN8094GTri Rotor Spray & Chemical · Ulysses, KSN8110VN8110v LLC · Havana, FLN8130GBank Of Utah Trustee · Salt Lake City, UTN8147VSchmitt Rudy · Brookshire, TXN8150VSchindler Flying Inc · Neligh, NEN8157VReady Aim Flyer LLC · New Castle, DEN8169VNelson Robert L · Fargo, NDN8262GRegistration Pending · Hampshire, ILRegistration pendingN8277GCountry Aero LLC · Darwin, MNN8288GFord Flying Service Inc · Doerun, GAN8296GKiehl Austin J · Winnett, MTN84497N84497 LLC · Omaha, NEN86407Donalds Flying Service Inc · Pantego, NCN86440Wilde Air Service-Huron LLC · Volga, SDN888BTSpraymax Corp · Miami, FL
Back to AD 68-07-07