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.
N4725DClover Park Technical College · Tacoma, WAN4725FHigh Peak Air LLC · Vernal, UTN4725GRegistration Pending · Tampa, FLRegistration pendingN4725KBoomerang Air LLC · Cedar Park, TXN4725UAntique Aircraft And Automobile LLC · Van Alstyne, TXN4726GAckerman Timothy M · Barnesville, OHN4726KEllis Thomas Troy · Slidell, LAN4726QBecker Flying Service Inc · Hartington, NEN4726UMonogram Aviation Services LLC · Coeur D Alene, IDN4726XDoebler H Andrew · Myrtle Beach, SCN4726YMeisner David B · Meridian, IDN4727D4 Leaf Clover Leasing LLC · Murrieta, CAN4727GDelaney Patrick · Marion, TXN4727KSchau Donna · Post Falls, IDN4727NState Of Wisconsin · Madison, WIN4727XN4727x LLC · Palmdale, CAN4728BN4728b Cessna 180 LLC · Colorado Springs, CON4728DMoore James Herbert III · Fairbanks, AKN4728GHidalgo Ciro R · Granbury, TXN4728KCloud Dodgers Flying Club Inc · The Villages, FLN4728NSouthern Aircraft Consultancy Inc Trustee · Casper, WYN4729CSullivan David C · St George, UTN4729KAlkire Jay · Boerne, TXN4729WMichael J Kraynick Pllc · Hailey, IDN472BWCernek Megan Faith · Elton, LAN472CMUniversity Of Central Missouri · Warrensburg, MON472DAlf Ix LLC · Chicago, ILN472ELAa-Aero LLC · Lewes, DEN472EREmbry Riddle Aeronautical University · Daytona Beach, FLN472JSTaylor Kirk B · Houston, TXN472KPB2 West Corp · Winona, MNN472NMMission Aviation Fellowship · Nampa, IDN472SPAmerican Aviation Inc · Brooksville, FLN472TWSkywest Leasing Inc · St George, UTN472WCJoe Morten & Son Inc · South Sioux City, NEN4730DRd Simpson Consulting LLC · Luling, TXN4730EState Of Alaska · Kodiak, AKN4730NThompson Sheila M · Natchez, MSN4730QLindsey Brad A · Dubois, WYN4730XDawson Allen J · Wshngtn Ct Hs, OHN4732VGeneral Aviation Support Corp · Rosamond, CAN4733DWycoff Shannon M · Baton Rouge, LAN4733N4733n LLC · Elberon, NJN4733UEicher Marlin Dale · Sterling, AKN4734EEnergy Transfer Aviation LLC · Spring, TXN4734NWood Daniel Matthew · Yelm, WAN4734XMclennon Daniel C · Boynton Beach, FLN4735NAnderson Wood Products LLC · Ellington, MON4735VCheney David R · Sun Lakes, AZN4736NHalter Irving L Jr · Philadelphia, PA
Back to AD 79-10-14 R1