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.
N4819QPuryear Rodney K · Pampa, TXN4834QWavra Mark F · East Grand Forks, MNN4841RBlack Gulch Aviation LLC · Polson, MTN4842QBlack Gulch Aviation LLC · Polson, MTN4843RFriesenborg & Larson Custom Spraying Lc · Buffalo Center, IAN4849JEast Side Mosquito Abatement District · Modesto, CAN4849QSouther Field Aviation Inc · Americus, GAN4851JAbernathy Spraying Service Inc · Tipton, OKN4854RFisher Ag Service LLC · Cardington, OHN4855RDefty Peter A · Visalia, CAN4863QKlamar Spraying Inc · Gatzke, MNN4881QAir Dakota Flite Inc. · Hettinger, NDN4890QNew Frontier Aviation LLC · Fort Benton, MTN4890RRebecca Lynn Flying Service Inc · Livingston, NYN4896QBecker Flying Service Inc · Hartington, NEN4896RB&R Aerial Crop Care Inc · Connell, WAN4898QTaylor Aviation Inc · Fort Benton, MTN4902RBecker Flying Service Inc · Hartington, NEN4904QFoxtrot Air LLC · Highmore, SDN4905RFlight Level Zero LLC · Othello, WAN4907RMills Spraying Service Inc · Pahokee, FLN4908Q1lowflyer Inc · Harrisonville, MON4914QGudgel Daniel R · Lemoore, CAN4921RBas Part Sales LLC · Greeley, CON4927QWakefield Aircraft LLC · Cooperstown, NDN4930RSouther Field Aviation Inc · Americus, GAN4931RRegistration Pending · Westhope, NDRegistration pendingN4933QDarter Lloyd R · Mountain Grove, MON4937RAllred Bobby A · Centre, ALN4939RMiller Farms Jv · Opheim, MTN4944RRoma Air Corp · Belle Glade, FLN4947QDavison Aviation LLC · Garnett, KSN4948RBlain Monte W · Joliet, MTN4949RValley Flying Service Inc · Orleans, NEN4958QSnider Scott E DBA · Turner, MTN4970QPettis Ag Aviation LLC · Atlantic, IAN4991REast Side Mosquito Abatement District · Modesto, CAN4994RCountry Air Service Inc · Hecla, SDN4KLRanspot Richard · Burlington, TXN53105Pence Dale E · Garnett, KSN53183Allred Gina D Administrator · Centre, ALN53211Anderson Aerial Spraying Service Inc · Canby, MNN53227Birddog Aviation LLC · Stockton, KSN53243Fly Low Aviation LLC · Ashley, NDN53245Kirk Ben C · Louisville, MSN53277Petecraft Aviation Services Inc · Plains, GAN53315Denton Aerial Spraying · Las Animas, CON53319Souther Field Aviation Inc · Americus, GAFirst renewal noticeN53368Arnt Aerial Spraying Inc · Worthington, MNN53391Schwend Brian · Forsyth, MT
Back to AD 68-07-07