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.
N8940GCapps Christopher N · Austin, TXN8940XKish John · Fort Mohave, AZN8941BBig R Of Greeley Inc · Greeley, CON8941TGeco Inc · Wilmington, DEN8941VSky Castle Aviation LLC · New Castle, INN8941XParrish Perry W · Columbia, KYN8942BBishops Sky Cam LLC · Jonesburg, MON8942GSale Reported · Stevensville, MTSale reported, canceledN8942TMonger Curtis V · Bend, ORN8942VPilots Flying School LLC · Englishtown, NJN8942XBlb Group LLC · Lake Havasu City, AZN8943BHarris David B III · Parlier, CAN8943GTruyaert Ivan R Jr · New Carlisle, INN8943VZiegler Aviation LLC · Minneapolis, MNN8944GSagra Nw LLC · Ronan, MTN8945TLumpkin Ed · Rosie, ARN8945XHarty Arthur · Acampo, CAN89464Freeway Airport Inc · Mitchellville, MDN8946BLumberjack LLC · Flagstaff, AZN8946VWings Over Texas Holdings LLC · Denton, TXN8946XKennedy Dennis R Trustee · Westlake Village, CAN8947BKaczmarek Richard G · Sandersville, GAN8947SMatyas Aviation Inc · Sugarloaf, PAN8947VMills Alan F · Chatom, ALN8947XN8947x LLC · Middletown, DEN8948GWilbur-Ellis Co · Salinas, CAN8948VPlain Company Ltd · Bloomfield Hills, MIN8948XRhodes Steven D · Anchorage, AKN8949GChuckanut Flying Club Inc · Bellingham, WAN894AHAerospace Asset Holdings LLC · Wilmington, DEN894CPCivil Air Patrol · Maxwell Afb, ALN894EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN894KCFlight Training Aircraft LLC · Wilmington, DEN89503Menne Aviation LLC · Brooklyn Park, MNN8950BPeppers Denise S · Centre, ALN8950TGribi Daniel M · Miranda, CAN8950XAnderson Craig M · Barron, WIN8951GThrash Helen · Pelahatchie, MSN8952TNorthwest Exteriors Inc · Rancho Cordova, CAN8953GAirfleet Solutions LLC · Newark, DEN8953TDouglass Jason E · Friday Harbor, WAN8953XHenning Jeffrey Carl · Prescott, AZN8954URausch John H · Fairport, NYN8954XGansz Kenneth L · Clare, IAN8955SHewett Donnie · Little River, SCN8955XPampa Office Supply · Elk City, OKN8956TBrown Donald L · Peoria, AZN8956XLove Brandon · Big Sandy, TXN8957BScott Larry R · Hobbs, NMN8957SMiller Andy · Marana, AZ
Back to AD 79-10-14 R1