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.
N9797TBasham James L · Livingston, TXN9797XDeckpro LLC · Rexburg, IDN97981Grindstaff Aircraft Leasing Inc · Crossville, TNN97984Woody George R · Clinton, ARN9798ARupert Yuri · Lillian, ALFirst renewal noticeN9798GJantz Merle Trustee · North Pole, AKN9798TRegistered aircraftN9798ZWright Air Service Inc · Fairbanks, AKN97993N97993 LLC · Middleton, MAN97995Lxs Farms LLC · El Paso, TXN97997Redline Aviation Inc · Sioux City, IAN9799ESkyhigh Trade LLC · Wilmington, DEN9799HFriehe Berend · Moses Lake, WAN9799TDeapen Jordan Derek · Clifton, TXN979BCMacinnis Charles E · Harbor Springs, MIN979BVTextron Aviation Inc · Wichita, KSN979CPCivil Air Patrol Inc · Maxwell Fb, ALN979EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN979JFGoodspeed Air Service LLC · Oxford, CTN979PTCappe Ivestment Group LLC · Homestead, FLN979WDDolphin Leasing LLC · Daytona Beach, FLN97ATRainier Flight Service LLC · Renton, WAN97AVCertified Aviation LLC · Dawson, GAN97BSSidewinder Services LLC · Genoa, NVN97DSWmg Aviation LLC · Ketchum, IDN97EKern County Sheriffs Department · Bakersfield, CAN97FAJalbert John E · Greenville, MEN97FCParker Cullen B · San Antonio, TXN97FFPeregrine Howard Fund V Owner LLC · New Orleans, LAN97FRSmith Ralph E · Lyndonville, NYN97HYFulghum Michael Eugene · Humble, TXN97JBVieira Nunes Da Silva Raphael · Ethel, LAN97LFSpengler Raymond Francis Jr · Longview, TXN97MWRudderworks Aviation LLC · Fairfax Station, VAN97PDBoeing Employees Flying Association Inc · Renton, WAN97RWWiplinger Robert D · Inver Grove Hts, MNN97VACamps Bay Aviation LLC · Waukegan, ILN9800JButts James Allen · Gainesville, GAN9800THerr Garrick D · Wasilla, AKN9801GTriad Aviation Academy LLC · Greensboro, NCN9802EPouya Hamid · San Jose, CAN9802HPatterson Aubrey III · Saltillo, MSN9802TSandford Graves M · Moberly, MON9802XMeise Fred W · Moses Lake, WAN9802ZBig Horn Aviation Group · Fort Worth, TXN9803CWhite Traci M · Manasquan, NJN9803HCoburn Alan B · Plantation, FLN9803VKoinzan Enterprises Inc · Elgin, NEN9803XPatrick Samuel Garrett · Durango, CON9803ZBig Horn Aviation Group · Fort Worth, TX
Back to AD 79-10-14 R1