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.
N7726FWargacki Darrin W · Hamilton, OHN7726XTop Profile Management LLC · Somis, CAN7727GSkyhawk Air LLC · Brunswick, GAN7727UWingtip Aviation LLC · Amarillo, TXN7728GTakeflight LLC · Spanish Fork, UTN7728UKropp Richard G · North Creek, NYN7729EMaldonado Abel N · Santa Maria, CAN7729FCardenas Enrique · Brownsville, TXN7729GValiair Lc Trustee · Casper, WYN7729UBlough Lynn M · Pittsburgh, PAN772CGBarefoot Brendan · Four Oaks, NCN772FGRidgeline Assets LLC · Wilmington, DEN772GKAmerican Aircraft Brokers LLC · Aurora, ORN772KWTime Flies LLC · Loxahatchee, FLN772MABaumbaugh Randal Kelly · Granger, INN772MSSchmidt Barnet M · Oradell, NJN772MVAir And Sea LLC · Oak Bluffs, MAN772PLSfc-182 LLC · Kansas City, MON772RAKehmeyer Aviation LLC · Bronson, MIN772RFSpencer John S · Indian, AKN772TXDyson Thornton E · Houston, TXN772ZZCirri Joseph A · Deming, NMN7730FBmg Aviation Leasing LLC · Bloomington, INN7730GSellet Jack A · Winter Haven, FLN7731FN7731f LLC · Portage, MIN7731KMorrison Richard Trustee · Anchorage, AKN7731TNash Leslie W · Bentonia, MSN7731UMd Aviation Inc · Sioux Falls, SDN7731VDedmon Stephen V · Fleming Island, FLN7732XLinstad Daniel E · Canby, ORN7733GWashingtons Mt St Helens Co Inc · Mill Creek, WAN7733TSiu Ena · Reno, NVN7733UGutlon Richard S · Durham, NCN7733VLong Final LLC · Clay, NYN7734ERegistration Pending · Cheyenne, WYRegistration pendingN7734FJackson Kimberly F · Wichita Falls, TXN7734XNelson Daniel J · Ladd, ILN7735GShaver John M · Shelby, NCN7736GKnudson Aviation LLC · Bozeman, MTN7736LSimmons David · Fremont, NEN7736UWatson Marshall · Sublette, KSN7736XSutton Aircraft Salvage LLC · Palmer, AKN7737FChapman John · San Antonio, TXN7737UMast Elroy T · Crawford, MSN7738EKrueger Arthur G · Cottonwood, CAN7738GCurioso Enrique Martin · Irvine, CAFirst renewal noticeN7738UGibson Nathaniel A · Cross Lanes, WVN7738XSutter William R · Hobart, WAN7739GFlyguys 172 LLC · Liberty, NCN773AAAlf Ix LLC · Chicago, IL
Back to AD 79-10-14 R1