AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N735UMonterey Bay Aviation Inc · Watsonville, CAFirst renewal noticeN735UAClemens Thomas M · Mount Gretna, PAN735UBAv8 One LLC · Lewes, DEN735UDBleakley Thomas L · Brookhaven, GAN735UFN735uf LLC · Evans, GAN735ULStraughn Matthew · Glenn Dale, MDN735UPSummitt Aviation LLC · Lake Mary, FLN735UQSkylane One LLC · Columbus, OHN735URDavis Howard R · Greenwood, MSN735UVFly-In LLC · Spanish Fort, ALN735UYAlexander Mark R · Waunakee, WIN735VAWaggoner David F Trustee · Aurora, ORN735VBShogry Louis M III · Lee, MAN735VCTalbott Tom · Tempe, AZN735VFSheffels James · Great Falls, MTN735VHKcsi Aerial Patrol Inc · Bakersfield, CAN735VKWelge Jack H Jr · Longview, TXN735VLAnderson William R · Overland Park, KSN735VMMorris Dale L · Yelm, WAN735VPMpc Aviation LLC · Homestead, FLN735VSFrench Steve · Jupiter, FLN735VVBw LLC · Denver, CON735VXRicupero Gary T Trustee · Monterey, CAN735WAPiro Anthony Michael · Groveland, CAN735WGWilliford Jason R · Randlett, OKN735WHTwining David S · Corvallis, ORN735WKRomper Aviation LLC · Boise, IDN735WLScott Lindsey · Toledo, WAN735WMHolland John E Trustee · Sharon Center, OHN735WRHuizenga Bruce A · Waupun, WIN735WTBlack Timber Industrial LLC · Silt, CON735WUCarter Gary James · Manlius, NYN735WWRegistered aircraftN735XEMant Thomas A · Diamond Springs, CAN735XFAlabama Aircraft Management LLC · Valley Head, ALN735XHTippair Inc · West Lafayette, INN735XMHansen Michael J · Marysville, WAN735XSCarbajal Juan Luis Sr · Gualala, CAN735XTVentura Aviation LLC · Emerald Isle, NCN735XVGps Land Company LLC · Brandon, MSN735XZRegistered aircraftN735YAMinnillo Vincent C · Ocala, FLN735YBRaulerson James · Holland, MON735YCLindsay Stephen J · Middletown, NYN735YGGiacomet Mauro · Portage, MIN735YJDuluth Ang Flying Club Inc · Cloquet, MNN735YLBlue Skies Aviation LLC · Lansing, MIN735YRGibbs Phillip G · Dubuque, IAN735YTVenturini Renato A Jr · Friendswood, TXN735YUObrien Daniel Joseph · Woburn, MA
Back to AD 79-10-14 R1