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.
N75611Ocala Aviation Services Inc · Ocala, FLN75612Difonzo Pete A · New Windsor, MDN75615Star Av8r LLC · Austell, GAN7561ELichodziejewski David J · Fountain Valley, CAN7561GNextgen Flight Academy Inc · Riverside, CAN7561NPierce County Sheriffs Department · South Hill, WAN7561SQuality Fliers LLC · Kennewick, WAN7561THendrickson David S · Hamptonville, NCN75620Nitta Jeffrey M · Waipahu, HIN75621Turo Ron · Mt Holly Spgs, PAN75626Fanning James F · Palm Coast, FLN75628Apm Leasing LLC · Casper, WYN7562FGreen Airports Development Corp · Kemah, TXN7562GWings Over Texas Holdings LLC · Denton, TXN7562QKaihai Corp · Wilmington, DEN7562SSnowridge LLC · Marysville, OHN7562TDupree Thomas J · Saranac Lake, NYN7562USchuebel Douglas R · Cameron, WIN75633Dauphinee Kevin Carl · Bingham, MEN75635Sarge Aviation LLC · Brazoria, TXN7563GOso Air LLC · Missoula, MTN7563SRusso Robert A · Chicago, ILN7563THaslam Jim M · Twain Harte, CAN7563XLogan Zachary R · Stamford, TXN75643Pecoraro Michael J · Gloucester, MAN75649New Horizons Aviation Inc · Goshen, INN7564ETama Aviation LLC · Ludington, MIN7564GRegistration Pending · Sterling, AKRegistration pendingN7564HYukon Air Service Inc · Fairbanks, AKN7564MAbkc LLC · Newark, DEN7564TRegistration Pending · Phoenix, AZRegistration pendingN7564USabatowich Erik J · Detroit, MIN7564XSodah One LLC · San Ramon, CAN75651Hansen Robert Alan · Horseheads, NYN75655Doane Dale A · Moreland, GAN7565DSiegle Daniel L · Birdsboro, PAN7565GB&R Aircraft LLC · Wadsworth, OHN7565HWright Kim B · Anchorage, AKN7565MLeaver Bros · Rossville, ILFirst renewal noticeN7565SExplore Air LLC · Kalispell, MTN7565VRehwald William J S · Santa Monica, CAN7566NBoedecker Brock · Sheridan, WYN7566SK7 Air LLC · Blanding, UTN7566TMerritt Joseph P · Pryor, OKN7566XKeenan Drew P · Chico, CAN7567GWhipple Eugene B · Mchenry, ILN7567QJolley Joseph J · Anchorage, AKN7568270 North LLC · Anchorage, AKN7568HEnergy Transfer Aviation LLC · Spring, TXN7568MPeters William R · Naperville, IL
Back to AD 79-10-14 R1